/// <summary> /// 获得一个实体对象 /// </summary> public Plan_Beginwork_Step GetModel(string strTrainPlanGUID, string strTrainmanGUID, int nStepID, SqlCommand command) { StringBuilder strSqlOption = new StringBuilder(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * "); strSql.Append(" FROM TAB_Plan_Beginwork_Step where 1=1 and strTrainPlanGUID = '{0}' and strTrainmanGUID = '{1}' and nStepID = {2} "); string newSql = string.Format(strSql.ToString(), strTrainPlanGUID, strTrainmanGUID, nStepID); //DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; command.CommandText = newSql.ToString(); command.CommandType = CommandType.Text; SqlDataAdapter sda = new SqlDataAdapter(command); DataTable dt = new DataTable(); sda.Fill(dt); Plan_Beginwork_Step _Plan_Beginwork_Step = null; if (dt.Rows.Count > 0) { _Plan_Beginwork_Step = new Plan_Beginwork_Step(); DataRowToModel(_Plan_Beginwork_Step, dt.Rows[0]); } return(_Plan_Beginwork_Step); }
/// <summary> /// 获得数据List /// </summary> public Plan_Beginwork_StepList GetDataList(Plan_Beginwork_StepQueryCondition QueryCondition) { SqlParameter[] sqlParams; StringBuilder strSqlOption = new StringBuilder(); QueryCondition.OutPut(out strSqlOption, out sqlParams); StringBuilder strSql = new StringBuilder(); if (QueryCondition.page == 0) { strSql.Append("select * "); strSql.Append(" FROM TAB_Plan_Beginwork_Step where 1=1 " + strSqlOption.ToString()); } else { strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Plan_Beginwork_Step where 1 = 1 " + strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows + " nID from TAB_Plan_Beginwork_Step where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc"); } DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; Plan_Beginwork_StepList list = null; if (dt.Rows.Count > 0) { list = new Plan_Beginwork_StepList(); foreach (DataRow dr in dt.Rows) { Plan_Beginwork_Step _Plan_Beginwork_Step = new Plan_Beginwork_Step(); DataRowToModel(_Plan_Beginwork_Step, dr); list.Add(_Plan_Beginwork_Step); } } return(list); }
/// <summary> /// 更新数据 /// </summary> public void Update(Plan_Beginwork_Step model, SqlCommand command) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update TAB_Plan_Beginwork_Step set "); strSql.Append(" strTrainPlanGUID = '{0}', "); strSql.Append(" nStepID = {1}, "); strSql.Append(" strTrainmanGUID = '{2}', "); strSql.Append(" strTrainmanNumber = '{3}', "); strSql.Append(" strTrainmanName = '{4}', "); strSql.Append(" nStepResultID = {5}, "); strSql.Append(" strStepResultText = '{6}', "); strSql.Append(" dtCreateTime =getdate(), "); strSql.Append(" dtEventTime = '{7}' "); strSql.Append(" dtEventEndTime = '{8}' "); strSql.Append(" where nID = {9} "); string NewSql = string.Format(strSql.ToString(), model.strTrainPlanGUID, model.nStepID, model.strTrainmanGUID, model.strTrainmanNumber, model.strTrainmanName, model.nStepResultID, model.strStepResultText, model.dtEventTime, model.dtEventEndTime, model.nID); command.CommandText = NewSql.ToString(); command.CommandType = CommandType.Text; command.ExecuteNonQuery(); }
/// <summary> /// 添加数据 /// </summary> public bool AddList(List <Plan_Beginwork_Step> modelList) { bool result = true; SqlConnection connection = new SqlConnection(); SqlTransaction transaction = null; SqlCommand command = new SqlCommand(); command.Connection = connection; connection.ConnectionString = SqlHelper.ConnString; connection.Open(); transaction = connection.BeginTransaction(); command.Transaction = transaction; Plan_Beginwork_StepQueryCondition QueryCondition = new Plan_Beginwork_StepQueryCondition(); try { foreach (Plan_Beginwork_Step model in modelList) { QueryCondition.strTrainPlanGUID = model.strTrainPlanGUID; QueryCondition.strTrainmanGUID = model.strTrainmanGUID; QueryCondition.nStepID = model.nStepID; Plan_Beginwork_Step tempModel = GetModel(model.strTrainPlanGUID, model.strTrainmanGUID, model.nStepID, command); if (tempModel == null) { Add(model, command); } else { model.nID = tempModel.nID; Update(model, command); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); result = false; } finally { if (connection.State != ConnectionState.Closed) { connection.Close(); } command.Dispose(); connection.Dispose(); } return(result); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(Plan_Beginwork_Step model, DataRow dr) { model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); model.nStepID = ObjectConvertClass.static_ext_int(dr["nStepID"]); model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID"]); model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]); model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]); model.nStepResultID = ObjectConvertClass.static_ext_int(dr["nStepResultID"]); model.strStepResultText = ObjectConvertClass.static_ext_string(dr["strStepResultText"]); model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]); model.dtEventTime = ObjectConvertClass.static_ext_date(dr["dtEventTime"]); model.dtEventEndTime = ObjectConvertClass.static_ext_date(dr["dtEventEndTime"]); model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); }
/// <summary> /// 检查数据是否存在 /// </summary> public bool Exists(Plan_Beginwork_Step _Plan_Beginwork_Step) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) from TAB_Plan_Beginwork_Step where strTrainPlanGUID=@strTrainPlanGUID an nStepID = @nStepID and strTrainmanGUID = @strTrainmanGUID"); SqlParameter[] parameters = { new SqlParameter("strTrainPlanGUID", _Plan_Beginwork_Step.strTrainPlanGUID), new SqlParameter("nStepID", _Plan_Beginwork_Step.nStepID), new SqlParameter("strTrainmanGUID", _Plan_Beginwork_Step.strTrainmanGUID) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)) > 0); }
public void Add(Plan_Beginwork_Step model, SqlTransaction trans) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_Plan_Beginwork_Step"); strSql.Append("(strTrainPlanGUID,nStepID,strTrainmanGUID,strTrainmanNumber,strTrainmanName,nStepResultID,strStepResultText,dtCreateTime,dtEventTime,dtEventEndTime)"); strSql.Append("values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',getdate(),'{7}','{8}')"); string NewSql = string.Format(strSql.ToString(), model.strTrainPlanGUID, model.nStepID, model.strTrainmanGUID, model.strTrainmanNumber, model.strTrainmanName, model.nStepResultID, model.strStepResultText, model.dtEventTime, model.dtEventEndTime); SqlHelper.ExecuteNonQuery(trans, CommandType.Text, NewSql.ToString()); }