/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(Plan_Beginwork_Rule model, DataRow dr) { model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]); model.strKeyStepName = ObjectConvertClass.static_ext_string(dr["strKeyStepName"]); model.nExecByStepIndex = ObjectConvertClass.static_ext_int(dr["nExecByStepIndex"]); model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); }
/// <summary> /// 检查数据是否存在 /// </summary> public bool Exists(Plan_Beginwork_Rule _Plan_Beginwork_Rule) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) from TAB_Plan_Beginwork_Rule where nID=@nID"); SqlParameter[] parameters = { new SqlParameter("nID", _Plan_Beginwork_Rule.nID) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)) > 0); }
/// <summary> /// 添加数据 /// </summary> public int Add(Plan_Beginwork_Rule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_Plan_Beginwork_Rule"); strSql.Append("(strWorkShopGUID,strWorkShopName,strKeyStepName,nExecByStepIndex)"); strSql.Append("values(@strWorkShopGUID,@strWorkShopName,@strKeyStepName,@nExecByStepIndex)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID), new SqlParameter("@strWorkShopName", model.strWorkShopName), new SqlParameter("@strKeyStepName", model.strKeyStepName), new SqlParameter("@nExecByStepIndex", model.nExecByStepIndex), }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters))); }
/// <summary> /// 获得数据List /// </summary> public Plan_Beginwork_RuleList GetExecByStepList(string strWorkShopGUID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM TAB_Plan_Beginwork_Rule where 1=1 and strWorkShopGUID='" + strWorkShopGUID + "' and len(nExecByStepIndex)>0 "); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0]; Plan_Beginwork_RuleList list = new Plan_Beginwork_RuleList(); foreach (DataRow dr in dt.Rows) { Plan_Beginwork_Rule _Plan_Beginwork_Rule = new Plan_Beginwork_Rule(); DataRowToModel(_Plan_Beginwork_Rule, dr); list.Add(_Plan_Beginwork_Rule); } return(list); }
/// <summary> /// 获得一个实体对象 /// </summary> public Plan_Beginwork_Rule GetModel(Plan_Beginwork_RuleQueryCondition QueryCondition) { SqlParameter[] sqlParams; StringBuilder strSqlOption = new StringBuilder(); QueryCondition.OutPut(out strSqlOption, out sqlParams); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * "); strSql.Append(" FROM TAB_Plan_Beginwork_Rule where 1=1 " + strSqlOption.ToString()); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; Plan_Beginwork_Rule _Plan_Beginwork_Rule = null; if (dt.Rows.Count > 0) { _Plan_Beginwork_Rule = new Plan_Beginwork_Rule(); DataRowToModel(_Plan_Beginwork_Rule, dt.Rows[0]); } return(_Plan_Beginwork_Rule); }