public static CostSubjectCollection GetCostSubjectInfos()
{
CostSubjectCollection subjects = new CostSubjectCollection();
string sqlString = "select * from Prj_Costsubjects where IsValid=1 and SecNum=0";
foreach (DataRow row in publicDbOpClass.DataTableQuary(sqlString).Rows)
{
CostSubjectInfo info = new CostSubjectInfo {
SubjectID = int.Parse(row["SubjectID"].ToString()),
FirstNum = int.Parse(row["FirstNum"].ToString()),
SubjectName = row["SubjectName"].ToString()
};
if (int.Parse(publicDbOpClass.ExecuteScalar(string.Format("select isNull(Count(*),0) from Prj_Costsubjects where firstNum={0} and secNum<>0 and IsValid=1", info.FirstNum)).ToString()) > 0)
{
info.IsHaveChild = true;
}
subjects.Add(info);
DataTable table = publicDbOpClass.DataTableQuary(string.Format("select * from Prj_Costsubjects where FirstNum={0} and IsValid=1 and secnum>0 order by secNum", info.FirstNum));
for (int i = 0; i < table.Rows.Count; i++)
{
CostSubjectInfo info2 = new CostSubjectInfo {
SubjectID = int.Parse(table.Rows[i]["SubjectID"].ToString()),
FirstNum = int.Parse(table.Rows[i]["FirstNum"].ToString()),
SubjectName = table.Rows[i]["SubjectName"].ToString(),
SecNum = int.Parse(table.Rows[i]["SecNum"].ToString())
};
subjects.Add(info2);
}
table.Dispose();
}
return(subjects);
}
public void CreateNewItem(object sender, EventArgs e)
{
CostSubjectCollection dataFromGrid = this.GetDataFromGrid();
CostSubjectCollection costSubjectCollection = new CostSubjectCollection();
for (int i = 0; i < dataFromGrid.Count; i++)
{
dataFromGrid[i].IsEdit = false;
if (i != 0 && dataFromGrid[i].FirstNum != dataFromGrid[i - 1].FirstNum && dataFromGrid[i - 1].FirstNum == int.Parse(this.hidFirst.Value))
{
CostSubjectInfo newItem = CostSubjectAction.GetNewItem(dataFromGrid[i - 1].FirstNum);
this.dgSubject.EditItemIndex = i;
costSubjectCollection.Add(newItem);
}
costSubjectCollection.Add(dataFromGrid[i]);
if (i == dataFromGrid.Count - 1 && dataFromGrid[i].FirstNum == int.Parse(this.hidFirst.Value))
{
CostSubjectInfo newItem2 = CostSubjectAction.GetNewItem(dataFromGrid[i].FirstNum);
this.dgSubject.EditItemIndex = i + 1;
costSubjectCollection.Add(newItem2);
}
}
this.dgSubject.DataSource = costSubjectCollection;
this.dgSubject.DataBind();
}
public UseCenterPoolCostCommand(string particularYear, decimal currentQuota, CenterCostUse centerCostUses, CenterCostBehaviorRecord centerCostBehaviorRecords, CostSubjectInfo costSubjectInfo)
{
_particularYear = particularYear;
_currentQuota = currentQuota;
CenterCostUses = centerCostUses;
CenterCostBehaviorRecords = centerCostBehaviorRecords;
CostSubjectInfo = costSubjectInfo;
}
public void usecenterpool()
{
CostSubjectInfo info = new CostSubjectInfo("23", "232", "434");
CenterCostUse entity1 = new CenterCostUse(100, "23", "34", "34", CostStaus.Frozen, info);
CenterCostBehaviorRecord record = new CenterCostBehaviorRecord(DateTime.Now, 11, "we", 1, "34", "sds", "dsd", "ww", 3);
var command = new UseCenterPoolCostCommand("2012", 100, entity1, record, info);
EventBus.TriggerAsync(command);
}
public static CostSubjectInfo GetNewItem(int FirstNum)
{
CostSubjectInfo info = new CostSubjectInfo();
string sqlString = string.Format("select Max(subjectId)+1 from Prj_Costsubjects", new object[0]);
info.SubjectID = int.Parse(publicDbOpClass.ExecuteScalar(sqlString).ToString());
info.SubjectName = "";
info.FirstNum = FirstNum;
sqlString = string.Format("select isNull(Max(secNum),0)+1 from Prj_Costsubjects where FirstNum={0} and isvalid=1", FirstNum);
info.SecNum = int.Parse(publicDbOpClass.ExecuteScalar(sqlString).ToString());
info.IsEdit = true;
info.IsValid = true;
return(info);
}
public static bool UpdateSubjectInfo(CostSubjectInfo objInfo)
{
string str;
if (publicDbOpClass.DataTableQuary("select * from Prj_Costsubjects where subjectId = " + objInfo.SubjectID.ToString()).Rows.Count > 0)
{
str = ("update Prj_Costsubjects set SubjectName='" + objInfo.SubjectName + "',IsValid=") + (objInfo.IsValid ? "1" : "0") + " where subjectId=" + objInfo.SubjectID.ToString();
}
else
{
str = "insert into Prj_Costsubjects(FirstNum,SecNum,SubjectName,IsValid) values(";
string str2 = str;
str = str2 + objInfo.FirstNum.ToString() + "," + objInfo.SecNum.ToString() + ",'" + objInfo.SubjectName + "',1);";
}
return(publicDbOpClass.NonQuerySqlString(str));
}
private CostSubjectCollection GetDataFromGrid()
{
CostSubjectCollection costSubjectCollection = new CostSubjectCollection();
foreach (System.Web.UI.WebControls.DataGridItem dataGridItem in this.dgSubject.Items)
{
CostSubjectInfo costSubjectInfo = new CostSubjectInfo();
costSubjectInfo.SubjectID = int.Parse(this.dgSubject.DataKeys[dataGridItem.ItemIndex].ToString());
costSubjectInfo.FirstNum = int.Parse(((System.Web.UI.HtmlControls.HtmlInputHidden)dataGridItem.FindControl("hidFirstNum")).Value);
costSubjectInfo.SecNum = int.Parse(((System.Web.UI.HtmlControls.HtmlInputHidden)dataGridItem.FindControl("hidSecNum")).Value);
costSubjectInfo.IsHaveChild = (((System.Web.UI.HtmlControls.HtmlInputHidden)dataGridItem.FindControl("hidIsHaveChild")).Value == "True");
if (((System.Web.UI.HtmlControls.HtmlInputHidden)dataGridItem.FindControl("hidIsEdit")).Value == "True")
{
costSubjectInfo.SubjectName = ((System.Web.UI.WebControls.TextBox)dataGridItem.FindControl("txtSubjectName")).Text;
}
else
{
costSubjectInfo.SubjectName = ((System.Web.UI.WebControls.Label)dataGridItem.FindControl("lbSubjectName")).Text;
}
costSubjectCollection.Add(costSubjectInfo);
}
return(costSubjectCollection);
}
