public Model_Two_WayChecklistToTestpaper DataRowToModel(DataRow row) { Model_Two_WayChecklistToTestpaper testpaper = new Model_Two_WayChecklistToTestpaper(); if (row != null) { if (row["Two_WayChecklistToTestpaper_Id"] != null) { testpaper.Two_WayChecklistToTestpaper_Id = row["Two_WayChecklistToTestpaper_Id"].ToString(); } if (row["Two_WayChecklist_Id"] != null) { testpaper.Two_WayChecklist_Id = row["Two_WayChecklist_Id"].ToString(); } if (row["ResourceToResourceFolder_Id"] != null) { testpaper.ResourceToResourceFolder_Id = row["ResourceToResourceFolder_Id"].ToString(); } if (row["CreateUser"] != null) { testpaper.CreateUser = row["CreateUser"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { testpaper.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } } return(testpaper); }
public bool Add(Model_Two_WayChecklistToTestpaper model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Two_WayChecklistToTestpaper("); builder.Append("Two_WayChecklistToTestpaper_Id,Two_WayChecklist_Id,ResourceToResourceFolder_Id,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@Two_WayChecklistToTestpaper_Id,@Two_WayChecklist_Id,@ResourceToResourceFolder_Id,@CreateUser,@CreateTime)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Two_WayChecklistToTestpaper_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; cmdParms[0].Value = model.Two_WayChecklistToTestpaper_Id; cmdParms[1].Value = model.Two_WayChecklist_Id; cmdParms[2].Value = model.ResourceToResourceFolder_Id; cmdParms[3].Value = model.CreateUser; cmdParms[4].Value = model.CreateTime; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int AddRelationPaper(Model_Two_WayChecklistToTestpaper model, List <Model_Two_WayChecklistDetailToTestQuestions> listModel) { Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>(); StringBuilder builder = new StringBuilder(); builder = new StringBuilder(); builder.Append("insert into Two_WayChecklistToTestpaper("); builder.Append("Two_WayChecklistToTestpaper_Id,Two_WayChecklist_Id,ResourceToResourceFolder_Id,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@Two_WayChecklistToTestpaper_Id,@Two_WayChecklist_Id,@ResourceToResourceFolder_Id,@CreateUser,@CreateTime)"); SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@Two_WayChecklistToTestpaper_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameterArray[0].Value = model.Two_WayChecklistToTestpaper_Id; parameterArray[1].Value = model.Two_WayChecklist_Id; parameterArray[2].Value = model.ResourceToResourceFolder_Id; parameterArray[3].Value = model.CreateUser; parameterArray[4].Value = model.CreateTime; dictionary.Add(builder.ToString(), parameterArray); int num = 0; foreach (Model_Two_WayChecklistDetailToTestQuestions questions in listModel) { num++; builder = new StringBuilder(); builder.AppendFormat("select {0}; ", num); builder.Append("insert into Two_WayChecklistDetailToTestQuestions("); builder.Append("Two_WayChecklistDetailToTestQuestions_Id,Two_WayChecklist_Id,Two_WayChecklistDetail_Id,ResourceToResourceFolder_Id,TestQuestions_Id,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@Two_WayChecklistDetailToTestQuestions_Id,@Two_WayChecklist_Id,@Two_WayChecklistDetail_Id,@ResourceToResourceFolder_Id,@TestQuestions_Id,@CreateUser,@CreateTime)"); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@Two_WayChecklistDetailToTestQuestions_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklistDetail_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@TestQuestions_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameterArray2[0].Value = questions.Two_WayChecklistDetailToTestQuestions_Id; parameterArray2[1].Value = questions.Two_WayChecklist_Id; parameterArray2[2].Value = questions.Two_WayChecklistDetail_Id; parameterArray2[3].Value = questions.ResourceToResourceFolder_Id; parameterArray2[4].Value = questions.TestQuestions_Id; parameterArray2[5].Value = questions.CreateUser; parameterArray2[6].Value = questions.CreateTime; dictionary.Add(builder.ToString(), parameterArray2); } int num2 = DbHelperSQL.ExecuteSqlTran(dictionary); if (num2 > 0) { return(num2); } return(0); }
public List <Model_Two_WayChecklistToTestpaper> DataTableToList(DataTable dt) { List <Model_Two_WayChecklistToTestpaper> list = new List <Model_Two_WayChecklistToTestpaper>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_Two_WayChecklistToTestpaper item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Update(Model_Two_WayChecklistToTestpaper model) { StringBuilder builder = new StringBuilder(); builder.Append("update Two_WayChecklistToTestpaper set "); builder.Append("Two_WayChecklist_Id=@Two_WayChecklist_Id,"); builder.Append("ResourceToResourceFolder_Id=@ResourceToResourceFolder_Id,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("CreateTime=@CreateTime"); builder.Append(" where Two_WayChecklistToTestpaper_Id=@Two_WayChecklistToTestpaper_Id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Two_WayChecklistToTestpaper_Id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.Two_WayChecklist_Id; cmdParms[1].Value = model.ResourceToResourceFolder_Id; cmdParms[2].Value = model.CreateUser; cmdParms[3].Value = model.CreateTime; cmdParms[4].Value = model.Two_WayChecklistToTestpaper_Id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int AddRelationPaper(Model_Two_WayChecklistToTestpaper model, List <Model_Two_WayChecklistDetailToTestQuestions> listModel) { return(this.dal.AddRelationPaper(model, listModel)); }
public bool Add(Model_Two_WayChecklistToTestpaper model) { return(this.dal.Add(model)); }
public bool Update(Model_Two_WayChecklistToTestpaper model) { return(this.dal.Update(model)); }