<%@ Page Language="C#" %>
<%@ Register Assembly="Coolite.Ext.Web" Namespace="Coolite.Ext.Web" TagPrefix="ext" %>
<%@ Import Namespace="System.Collections.Generic"%>
<%@ Import Namespace="System.Xml"%>
<%@ Register assembly="System.Web.DynamicData, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.DynamicData" tagprefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>CRM Mitarbeiterauslastung</title>
<script runat="server">
string akqguid = "";
string akqnr = "";
string akqstat = "";
string akqunternehmen = "";
string aktjahr = "";
protected void Page_Load(object sender, EventArgs e)
{
this.Store3.DataSource = new object[]
{
new object[]{"EINS",DateTime.Now.Year.ToString()},
new object[]{"ZWEI",DateTime.Now.AddYears(1).Year.ToString()},
new object[]{"DREI",DateTime.Now.AddYears(2).Year.ToString()},
new object[]{"VIER",DateTime.Now.AddYears(-1).Year.ToString()},
new object[]{"FUENF",DateTime.Now.AddYears(-2).Year.ToString()}
};
this.Store3.DataBind();
if (!IsPostBack)
{
ComboBox1.SelectedItem.Value = DateTime.Now.Year.ToString();
//NumberField3.Text = DateTime.Now.Year.ToString();
akqguid = Request.QueryString["akqguid"];
akqnr = "123456";// Request.QueryString["akqnr"];
akqstat = Request.QueryString["akqstat"];
akqunternehmen = Request.QueryString["akqunternehmen"];
Hidden1.Text = akqnr;
//NumberField1.Text = DateTime.Now.Year.ToString();
SqlDataSource1.ConnectionString = "Data Source=STGT-WINDB-TEST;Initial Catalog=DBMis;Integrated Security=False;User=MAA;Password=crmMAA;";
SqlDataSource1.SelectCommand = "SELECT s1.akquiseprojekt_id, s1.sb_id, s1.jahr, s1.monat AS Jan, s1.stunden AS JanStd, s1.ma_name, s2.monat AS Feb, s2.stunden AS FebStd,";
SqlDataSource1.SelectCommand += " s3.monat AS Mar, s3.stunden AS MarStd, s4.monat AS Apr, s4.stunden AS AprStd, s5.monat AS May, s5.stunden AS MayStd, s6.monat AS Jun,";
SqlDataSource1.SelectCommand += " s6.stunden AS JunStd, s7.monat AS Jul, s7.stunden AS JulStd, s8.monat AS Aug, s8.stunden AS AugStd, s9.monat AS Sep, s9.stunden AS SepStd,";
SqlDataSource1.SelectCommand += " s10.monat AS Oct, s10.stunden AS OctStd, s11.monat AS Nov, s11.stunden AS NovStd, s12.monat AS Dec, s12.stunden AS DecStd";
SqlDataSource1.SelectCommand += " FROM akquise_dispo_stunden AS s1 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s2 ON s1.sb_id = s2.sb_id AND s1.jahr = s2.jahr AND s1.monat = 1 AND s2.monat = 2 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s3 ON s1.sb_id = s3.sb_id AND s1.jahr = s3.jahr AND s1.monat = 1 AND s3.monat = 3 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s4 ON s1.sb_id = s4.sb_id AND s1.jahr = s4.jahr AND s1.monat = 1 AND s4.monat = 4 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s5 ON s1.sb_id = s5.sb_id AND s1.jahr = s5.jahr AND s1.monat = 1 AND s5.monat = 5 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s6 ON s1.sb_id = s6.sb_id AND s1.jahr = s6.jahr AND s1.monat = 1 AND s6.monat = 6 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s7 ON s1.sb_id = s7.sb_id AND s1.jahr = s7.jahr AND s1.monat = 1 AND s7.monat = 7 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s8 ON s1.sb_id = s8.sb_id AND s1.jahr = s8.jahr AND s1.monat = 1 AND s8.monat = 8 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s9 ON s1.sb_id = s9.sb_id AND s1.jahr = s9.jahr AND s1.monat = 1 AND s9.monat = 9 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s10 ON s1.sb_id = s10.sb_id AND s1.jahr = s10.jahr AND s1.monat = 1 AND s10.monat = 10 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s11 ON s1.sb_id = s11.sb_id AND s1.jahr = s11.jahr AND s1.monat = 1 AND s11.monat = 11 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s12 ON s1.sb_id = s12.sb_id AND s1.jahr = s12.jahr AND s1.monat = 1 AND s12.monat = 12";
SqlDataSource1.SelectCommand += " WHERE (s1.sb_ID = s2.sb_id) AND (s1.akquiseprojekt_id = '" + Hidden1.Value.ToString() + "') AND (s1.jahr = '" + ComboBox1.SelectedItem.Value.ToString() + "')";
}
}
private bool cancel;
private string message;
protected void Store1_BeforeRecordInserted(object sender, BeforeRecordInsertedEventArgs e)
{
//TextField4.Text = "0";
/*SqlDataSource1.InsertParameters.Add("@sb_id", GridPanel1.;
SqlDataSource1.InsertParameters.Add("@FebStd", TextField5.Text);
SqlDataSource1.InsertParameters.Add("@jahr", NumberField1.Text);
//SqlDataSource1.InsertParameters.Add("@ma_name", ComboMAName.Value.ToString());
SqlDataSource1.InsertCommand = "INSERT INTO akquise_dispo_stunden(sb_id,akquiseprojekt_id,monat,jahr,ma_name,stunden) VALUES (@sb_id,'test',2,@jahr,@ma_name,@FebStd)";
SqlDataSource1.Insert();*/
}
public void departmentRenderer(object sender, AfterAjaxEventArgs e)
{
}
public void Store1_AfterRecordInserted(object sender, AfterRecordInsertedEventArgs e)
{
//The deleted and updated records confirms automatic (depending AffectedRows field)
//But you can override this in AfterRecordUpdated and AfterRecordDeleted event
//For insert we should set new id for refresh on client
//If we don't set new id then old id will be used
/*if (e.Confirmation.Confirm && !string.IsNullOrEmpty(insertedValue))
{
e.Confirmation.ConfirmRecord(insertedValue);
insertedValue = "";
}*/
}
private string insertedValue;
protected void SqlDataSource1_Inserted(object sender, SqlDataSourceStatusEventArgs e)
{
//use e.AffectedRows for ensure success action. The store read this value and set predefined Confirm depend on e.AffectedRows
//The Confirm can be granted or denied in OnRecord....ed event
insertedValue = e.Command.Parameters["@sb_id"].Value != null
? e.Command.Parameters["@sb_id"].Value.ToString()
: "";
}
protected void Store1_AfterAjaxEvent(object sender, AfterAjaxEventArgs e)
{
if (e.Response.Success)
{
// set to .Success to false if we want to return a failure
e.Response.Success = !cancel;
e.Response.Msg = message;
}
}
protected void Store1_BeforeAjaxEvent(object sender, BeforeAjaxEventArgs e)
{
/*string emulError = e.Parameters["EmulateError"];
if (emulError == "1")
{
throw new Exception("Emulating error");
}*/
}
protected void switchYear(object sender, EventArgs e)
{
GridPanel1.Reload();
}
public void Store1_RefershData(object sender, EventArgs e)
{
//DateTime dt = new DateTime();
//dt = DateField1;
//aktjahr = DateField1.yToString();
SqlDataSource1.ConnectionString = "Data Source=STGT-WINDB-TEST;Initial Catalog=DBMis;Integrated Security=False;User=MAA;Password=crmMAA;";
SqlDataSource1.SelectCommand = "SELECT s1.akquiseprojekt_id, s1.sb_id, s1.jahr, s1.monat AS Jan, s1.stunden AS JanStd, s1.ma_name, s2.monat AS Feb, s2.stunden AS FebStd,";
SqlDataSource1.SelectCommand += " s3.monat AS Mar, s3.stunden AS MarStd, s4.monat AS Apr, s4.stunden AS AprStd, s5.monat AS May, s5.stunden AS MayStd, s6.monat AS Jun,";
SqlDataSource1.SelectCommand += " s6.stunden AS JunStd, s7.monat AS Jul, s7.stunden AS JulStd, s8.monat AS Aug, s8.stunden AS AugStd, s9.monat AS Sep, s9.stunden AS SepStd,";
SqlDataSource1.SelectCommand += " s10.monat AS Oct, s10.stunden AS OctStd, s11.monat AS Nov, s11.stunden AS NovStd, s12.monat AS Dec, s12.stunden AS DecStd";
SqlDataSource1.SelectCommand += " FROM akquise_dispo_stunden AS s1 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s2 ON s1.sb_id = s2.sb_id AND s1.jahr = s2.jahr AND s1.monat = 1 AND s2.monat = 2 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s3 ON s1.sb_id = s3.sb_id AND s1.jahr = s3.jahr AND s1.monat = 1 AND s3.monat = 3 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s4 ON s1.sb_id = s4.sb_id AND s1.jahr = s4.jahr AND s1.monat = 1 AND s4.monat = 4 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s5 ON s1.sb_id = s5.sb_id AND s1.jahr = s5.jahr AND s1.monat = 1 AND s5.monat = 5 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s6 ON s1.sb_id = s6.sb_id AND s1.jahr = s6.jahr AND s1.monat = 1 AND s6.monat = 6 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s7 ON s1.sb_id = s7.sb_id AND s1.jahr = s7.jahr AND s1.monat = 1 AND s7.monat = 7 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s8 ON s1.sb_id = s8.sb_id AND s1.jahr = s8.jahr AND s1.monat = 1 AND s8.monat = 8 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s9 ON s1.sb_id = s9.sb_id AND s1.jahr = s9.jahr AND s1.monat = 1 AND s9.monat = 9 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s10 ON s1.sb_id = s10.sb_id AND s1.jahr = s10.jahr AND s1.monat = 1 AND s10.monat = 10 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s11 ON s1.sb_id = s11.sb_id AND s1.jahr = s11.jahr AND s1.monat = 1 AND s11.monat = 11 LEFT OUTER JOIN";
SqlDataSource1.SelectCommand += " akquise_dispo_stunden AS s12 ON s1.sb_id = s12.sb_id AND s1.jahr = s12.jahr AND s1.monat = 1 AND s12.monat = 12";
SqlDataSource1.SelectCommand += " WHERE (s1.sb_ID = s2.sb_id) AND (s1.akquiseprojekt_id = '" + Hidden1.Value.ToString() + "') AND (s1.jahr = '" + ComboBox1.SelectedItem.Value.ToString() + "')";
this.Store1.DataBind();
}
//hier Firmenbezogen
protected void maRefresh(object sender,EventArgs e)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(HttpContext.Current.Server.MapPath("ma.xml"));
List<object> data = new List<object>();
foreach (XmlNode employeeNode in xmlDoc.SelectNodes("EMPLOYEES/MA"))
{
string id = employeeNode.SelectSingleNode("SBID").InnerText;
string name = employeeNode.SelectSingleNode("FULLNAME").InnerText;
string faname = employeeNode.SelectSingleNode("FANAME").InnerText;
name += " " + "(" + id + ")";
data.Add(new { Id = id, Name = name });
}
this.maStore.DataSource = data;
this.maStore.DataBind();
}
public void ComboMaName_OnSelect(object sender,EventArgs e)
{
//TextField1.Text = "1200";
}
protected void NumberField1_TextChanged(object sender, EventArgs e)
{
}
protected void Hidden1_ValueChanged(object sender, EventArgs e)
{
}
</script>
<style type="text/css">
.search-item {
font: normal 11px tahoma, arial, helvetica, sans-serif;
padding: 3px 10px 3px 10px;
border: 1px solid #fff;
border-bottom: 1px solid #eeeeee;
white-space: normal;
color: #555;
}
.search-item h3 {
display: block;
font: inherit;
font-weight: bold;
color: #222;
}
.search-item h3 span {
float: right;
font-weight: normal;
margin: 0 0 5px 5px;
width: 100px;
display: block;
clear: none;
}
p { width: 350px; }
.ext-ie .x-form-text { position: static !important; }
#Text1
{
width: 128px;
}
.style4
{
width: 110px;
}
</style>
</head>
<script type="text/javascript">
MASelected = function() {
//Clear the value first
ComboPers.clearValue();
//Load the store
ComboPers.doQuery(ComboMAName.store.getById(ComboMAName.getValue()).get('Persid'), true);
//Set the value
ComboPers.setValue(ComboMAName.getValue());
}
</script>
<body>
<form id="form1" runat="server">
<ext:ScriptManager ID="ScriptManager1" runat="server" StateProvider="None" ScriptMode="Debug">
</ext:ScriptManager>
<ext:Store ID="Store1" runat="server"
DataSourceID="SqlDataSource1"
OnAfterAjaxEvent="Store1_AfterAjaxEvent"
OnBeforeAjaxEvent="Store1_BeforeAjaxEvent"
UseIdConfirmation="true"
OnBeforeRecordInserted="Store1_BeforeRecordInserted"
OnAfterRecordInserted="Store1_AfterRecordInserted"
OnRefreshData="Store1_RefershData">
<Reader>
<ext:JsonReader ReaderID="sb_id">
<Fields>
<ext:RecordField Name="sb_id" />
<ext:RecordField Name="ma_name" />
<ext:RecordField Name="JanStd" />
<ext:RecordField Name="FebStd" />
<ext:RecordField Name="MarStd" />
<ext:RecordField Name="AprStd" />
<ext:RecordField Name="MayStd" />
<ext:RecordField Name="JunStd" />
<ext:RecordField Name="JulStd" />
<ext:RecordField Name="AugStd" />
<ext:RecordField Name="SepStd" />
<ext:RecordField Name="OctStd" />
<ext:RecordField Name="NovStd" />
<ext:RecordField Name="DecStd" />
</Fields>
</ext:JsonReader>
</Reader>
<SortInfo Field="sb_id" Direction="ASC" />
<Listeners>
<LoadException Handler="Ext.Msg.alert('Laden fehlgeschlagen', e.message || e )" />
<CommitFailed Handler="Ext.Msg.alert('nderung fehlgeschlagen', 'Ursache: ' + msg)" />
<CommitDone Handler="Ext.Msg.alert('nderung erfolgreich', 'Daten erfolgreich gespeichert');" />
<SaveException Handler="Ext.Msg.alert('Speichern fehlgeschlagen', e.message || e)" />
</Listeners>
</ext:Store>
<ext:Store runat="server" ID="Store2">
<Proxy>
<ext:HttpProxy Method="POST" Url="Employees.ashx" />
</Proxy>
<Reader>
<ext:JsonReader Root="employees" TotalProperty="totalCount" >
<Fields>
<ext:RecordField Name="Common" />
<ext:RecordField Name="Vorname" />
<ext:RecordField Name="Fullname" />
<ext:RecordField Name="Persid" />
<ext:RecordField Name="ma_name" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
<ext:Store ID="Store3" runat="server" AutoLoad="true">
<Reader>
<ext:ArrayReader>
<Fields>
<ext:RecordField Name="id" />
<ext:RecordField Name="jahreszahl" />
</Fields>
</ext:ArrayReader>
</Reader>
</ext:Store>
<ext:Store runat="server" ID="maStore" AutoLoad="false" OnLoad="maRefresh">
<AjaxEventConfig>
<EventMask ShowMask="false" />
</AjaxEventConfig>
<Reader>
<ext:JsonReader ReaderID="Id">
<Fields>
<ext:RecordField Name="id" Type="String" Mapping="Id" />
<ext:RecordField Name="name" Type="String" Mapping="Name" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Data Source=STGT-WINDB-TEST;Initial Catalog=DBMis;Integrated Security=False;User=MAA;Password=crmMAA;"
DeleteCommand="DELETE FROM akquise_dispo_stunden WHERE ((sb_id = @sb_id) AND (jahr = CONVERT(int,@jahr)) AND (akquiseprojekt_id = @akquisenr))"
InsertCommand="INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,1,CONVERT(int,@jahr),@JanStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,2,CONVERT(int,@jahr),@FebStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,3,CONVERT(int,@jahr),@MarStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,4,CONVERT(int,@jahr),@AprStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,5,CONVERT(int,@jahr),@MayStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,6,CONVERT(int,@jahr),@JunStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,7,CONVERT(int,@jahr),@JulStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,8,CONVERT(int,@jahr),@AugStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,9,CONVERT(int,@jahr),@SepStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,10,CONVERT(int,@jahr),@OctStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,11,CONVERT(int,@jahr),@NovStd);
INSERT INTO akquise_dispo_stunden(ma_name,akquiseprojekt_id,monat,jahr,stunden)VALUES(@ma_name,@akquisenr,12,CONVERT(int,@jahr),@DecStd);"
SelectCommand="SELECT s1.akquiseprojekt_id, s1.sb_id, s1.jahr, s1.monat AS Jan, s1.stunden AS JanStd, s1.ma_name, s2.monat AS Feb, s2.stunden AS FebStd,
s3.monat AS Mar, s3.stunden AS MarStd, s4.monat AS Apr, s4.stunden AS AprStd, s5.monat AS May, s5.stunden AS MayStd, s6.monat AS Jun,
s6.stunden AS JunStd, s7.monat AS Jul, s7.stunden AS JulStd, s8.monat AS Aug, s8.stunden AS AugStd, s9.monat AS Sep, s9.stunden AS SepStd,
s10.monat AS Oct, s10.stunden AS OctStd, s11.monat AS Nov, s11.stunden AS NovStd, s12.monat AS Dec, s12.stunden AS DecStd
FROM akquise_dispo_stunden AS s1 LEFT OUTER JOIN
akquise_dispo_stunden AS s2 ON s1.sb_id = s2.sb_id AND s1.jahr = s2.jahr AND s1.monat = 1 AND s2.monat = 2 LEFT OUTER JOIN
akquise_dispo_stunden AS s3 ON s1.sb_id = s3.sb_id AND s1.jahr = s3.jahr AND s1.monat = 1 AND s3.monat = 3 LEFT OUTER JOIN
akquise_dispo_stunden AS s4 ON s1.sb_id = s4.sb_id AND s1.jahr = s4.jahr AND s1.monat = 1 AND s4.monat = 4 LEFT OUTER JOIN
akquise_dispo_stunden AS s5 ON s1.sb_id = s5.sb_id AND s1.jahr = s5.jahr AND s1.monat = 1 AND s5.monat = 5 LEFT OUTER JOIN
akquise_dispo_stunden AS s6 ON s1.sb_id = s6.sb_id AND s1.jahr = s6.jahr AND s1.monat = 1 AND s6.monat = 6 LEFT OUTER JOIN
akquise_dispo_stunden AS s7 ON s1.sb_id = s7.sb_id AND s1.jahr = s7.jahr AND s1.monat = 1 AND s7.monat = 7 LEFT OUTER JOIN
akquise_dispo_stunden AS s8 ON s1.sb_id = s8.sb_id AND s1.jahr = s8.jahr AND s1.monat = 1 AND s8.monat = 8 LEFT OUTER JOIN
akquise_dispo_stunden AS s9 ON s1.sb_id = s9.sb_id AND s1.jahr = s9.jahr AND s1.monat = 1 AND s9.monat = 9 LEFT OUTER JOIN
akquise_dispo_stunden AS s10 ON s1.sb_id = s10.sb_id AND s1.jahr = s10.jahr AND s1.monat = 1 AND s10.monat = 10 LEFT OUTER JOIN
akquise_dispo_stunden AS s11 ON s1.sb_id = s11.sb_id AND s1.jahr = s11.jahr AND s1.monat = 1 AND s11.monat = 11 LEFT OUTER JOIN
akquise_dispo_stunden AS s12 ON s1.sb_id = s12.sb_id AND s1.jahr = s12.jahr AND s1.monat = 1 AND s12.monat = 12
WHERE (s1.sb_ID = s2.sb_id) AND (s1.akquiseprojekt_id = @akquisenr) AND (s1.jahr = @jahr);"
UpdateCommand="UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @JanStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 1));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @FebStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 2));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @MarStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 3));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @AprStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 4));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @MayStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 5));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @JunStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 6));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @JulStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 7));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @AugStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 8));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @SepStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 9));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @OctStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 10));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @NovStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 11));
UPDATE akquise_dispo_stunden SET sb_id = @sb_id, akquiseprojekt_id = @akquisenr,stunden = @DecStd WHERE ((sb_id = @sb_id) AND (jahr = @jahr) AND (akquiseprojekt_id = @akquisenr) AND (monat = 12));"
OnInserted="SqlDataSource1_Inserted" ProviderName="System.Data.SqlClient">
<DeleteParameters>
<asp:Parameter Name="sb_id" Type="Int32" />
<asp:FormParameter Name="jahr" FormField="ComboBox1" Type="String" />
<asp:FormParameter Name="akquisenr" FormField="Hidden1" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="sb_id" Type="Int32" />
<asp:Parameter Name="ma_name" Type="String" />
<asp:FormParameter Name="jahr" FormField="ComboBox1" Type="String" />
<asp:FormParameter Name="akquisenr" FormField="Hidden1" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ma_name" Type="String" />
<asp:FormParameter Name="jahr" FormField="ComboBox1" Type="String" />
<asp:FormParameter Name="akquisenr" FormField="Hidden1" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<ext:ViewPort ID="ViewPort1" runat="server" >
<Body>
<ext:BorderLayout ID="BorderLayout1" runat="server">
<North MarginsSummary="5 5 5 5">
<ext:Panel ID="Panel1" runat="server" Title="Akquiseprojekt" Height="90" BodyStyle="padding: 5px;"
Frame="true" Icon="MoneyEuro" >
<Body>
<ext:Hidden ID="Hidden1" runat="server" />
<table style="width:400px; height: 40px;">
<tr>
<td class="style4">
<ext:ComboBox ID="ComboBox1"
runat="server"
StoreID="Store3"
Editable="true"
DisplayField="jahreszahl"
ValueField="jahreszahl"
TypeAhead="true"
Mode="Local"
ForceSelection="true"
TriggerAction="All"
Width="80px"
MaxLength="4"
MinLength="4"
SelectOnFocus="true">
<Listeners>
<Select Handler="#{GridPanel1}.reload();" />
</Listeners>
</ext:ComboBox>
</td>
<td class="style4" align="right">
<ext:Button ID="btnInsert" runat="server" Text="MA hinzufgen" Icon="Add">
<Listeners>
<Click Handler="#{GridPanel1}.insertRecord(0, {});#{GridPanel1}.getView().focusRow(0);#{GridPanel1}.startEditing(0, 0);" />
</Listeners>
</ext:Button>
</td>
<td class="style4" align="right">
<ext:Button ID="btnDelete" runat="server" Text="ausgewhlte MA lschen" Icon="Delete">
<Listeners>
<Click Handler="#{GridPanel1}.deleteSelected();" />
</Listeners>
</ext:Button>
</td>
<td class="style4" align="left">
<ext:Button ID="btnSave" runat="server" Text="Speichern" Icon="Disk">
<Listeners>
<Click Handler="#{GridPanel1}.save();" />
</Listeners>
</ext:Button>
</td>
<td class="style4" align="right">
<ext:Button ID="btnRefresh" runat="server" Icon="ArrowRefresh" Text="Aktualisieren">
<Listeners>
<Click Handler="#{GridPanel1}.reload();" />
</Listeners>
</ext:Button>
</td>
</table>
</Body>
<Buttons>
</Buttons>
</ext:Panel>
</North>
<Center MarginsSummary="0 5 0 5">
<ext:Panel ID="Panel2" runat="server" Height="300" Header="false">
<Body>
<ext:FitLayout ID="FitLayout1" runat="server">
<ext:GridPanel ID="GridPanel1" runat="server" Title="CRM - Mitarbeiterauslastung"
StoreID="Store1" Border="false" Icon="Clock">
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ColumnID="ma_name" DataIndex="ma_name" Header="Mitarbeiter Name" Width="190">
<Editor>
<ext:ComboBox
ID="ComboMAName"
runat="server"
StoreID="Store2"
DisplayField="Fullname"
ValueField="Fullname"
TypeAhead="false"
LoadingText="Suchen..."
Width="185"
PageSize="10"
HideTrigger="true"
SelectOnFocus="true"
MinChars="1">
</ext:ComboBox>
</Editor>
</ext:Column>
<ext:Column DataIndex="JanStd" Header="JAN" Width="50">
<Editor>
<ext:TextField ID="TextField4" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="FebStd" Header="FEB" Width="50">
<Editor>
<ext:TextField ID="TextField5" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="MarStd" Header="MAR" Width="50">
<Editor>
<ext:TextField ID="TextField6" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="AprStd" Header="APR" Width="50">
<Editor>
<ext:TextField ID="TextField7" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="MayStd" Header="MAI" Width="50">
<Editor>
<ext:TextField ID="TextField8" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="JunStd" Header="JUN" Width="50">
<Editor>
<ext:TextField ID="TextField9" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="JulStd" Header="JUL" Width="50">
<Editor>
<ext:TextField ID="TextField10" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="AugStd" Header="AUG" Width="50">
<Editor>
<ext:TextField ID="TextField11" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="SepStd" Header="SEP" Width="50">
<Editor>
<ext:TextField ID="TextField12" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="OctStd" Header="OKT" Width="50">
<Editor>
<ext:TextField ID="TextField13" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="NovStd" Header="NOV" Width="50">
<Editor>
<ext:TextField ID="TextField14" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="DecStd" Header="DEZ" Width="50">
<Editor>
<ext:TextField ID="TextField15" BlankText="0" SelectOnFocus="true" runat="server" />
</Editor>
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server"/>
</SelectionModel>
<BottomBar>
<ext:PagingToolBar ID="PagingToolBar1" runat="server" PageSize="15" StoreID="Store1" DisplayInfo="false" />
</BottomBar>
<SaveMask ShowMask="true" />
<LoadMask ShowMask="true" />
</ext:GridPanel>
</ext:FitLayout>
</Body>
</ext:Panel>
</Center>
</ext:BorderLayout>
</Body>
</ext:ViewPort>
</form>
</body>
</html>
