public BindBudget GetModel(int NoteId) { string sqlString = ""; sqlString = "select NoteId,PrjCode,Templatescode,TaskCode from BindBudget "; sqlString = sqlString + " where NoteId=" + NoteId; BindBudget budget = new BindBudget(); DataSet set = publicDbOpClass.DataSetQuary(sqlString); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["NoteId"].ToString() != "") { budget.NoteId = Convert.ToInt32(set.Tables[0].Rows[0]["NoteId"].ToString()); } if (set.Tables[0].Rows[0]["PrjCode"].ToString() != "") { budget.PrjCode = new Guid(set.Tables[0].Rows[0]["PrjCode"].ToString()); } budget.Templatescode = set.Tables[0].Rows[0]["Templatescode"].ToString(); budget.TaskCode = set.Tables[0].Rows[0]["TaskCode"].ToString(); return(budget); }
public bool Update(BindBudget model) { string str = ""; str = "update BindBudget set "; return(publicDbOpClass.ExecSqlString(((string.Concat(new object[] { str, "PrjCode='", model.PrjCode, "'," }) + "Templatescode='" + model.Templatescode + "',") + "TaskCode='" + model.TaskCode + "'") + " where NoteId=" + model.NoteId) > 0); }
public static bool Add(BindBudget model) { string str = ""; str = "insert into BindBudget("; str = str + "PrjCode,Templatescode,TaskCode)" + " values ('"; return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { str, model.PrjCode, "','", model.Templatescode, "','", model.TaskCode, "')" })) > 0); }