/// <summary>
/// 获得数据List
/// </summary>
public DDML_ConfirmList GetDataList(DDML_ConfirmQueryCondition 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_DDML_Confirm where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_DDML_Confirm where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_DDML_Confirm where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DDML_ConfirmList list = new DDML_ConfirmList();
foreach (DataRow dr in dt.Rows)
{
DDML_Confirm _DDML_Confirm = new DDML_Confirm();
DataRowToModel(_DDML_Confirm, dr);
list.Add(_DDML_Confirm);
}
return(list);
}
/// <summary>
/// 更新数据
/// </summary>
public bool Update(DDML_Confirm model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update TAB_DDML_Confirm set ");
strSql.Append(" strGUID = @strGUID, ");
strSql.Append(" strWorkShopGUID = @strWorkShopGUID, ");
strSql.Append(" strWorkShopNumber = @strWorkShopNumber, ");
strSql.Append(" strWorkShopName = @strWorkShopName, ");
strSql.Append(" dtConfirmTime = @dtConfirmTime, ");
strSql.Append(" strDutyUserNumber = @strDutyUserNumber, ");
strSql.Append(" strDutyUserName = @strDutyUserName ");
strSql.Append(" where nID = @nID ");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", model.strGUID),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopNumber", model.strWorkShopNumber),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@dtConfirmTime", model.dtConfirmTime),
new SqlParameter("@strDutyUserNumber", model.strDutyUserNumber),
new SqlParameter("@strDutyUserName", model.strDutyUserName),
new SqlParameter("@nID", model.nID)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(DDML_Confirm model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
model.strWorkShopNumber = ObjectConvertClass.static_ext_string(dr["strWorkShopNumber"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
model.dtConfirmTime = ObjectConvertClass.static_ext_date(dr["dtConfirmTime"]);
model.strDutyUserNumber = ObjectConvertClass.static_ext_string(dr["strDutyUserNumber"]);
model.strDutyUserName = ObjectConvertClass.static_ext_string(dr["strDutyUserName"]);
}
/// <summary>
/// 检查数据是否存在
/// </summary>
public bool Exists(DDML_Confirm _DDML_Confirm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from TAB_DDML_Confirm where strWorkShopGUID=@strWorkShopGUID");
SqlParameter[] parameters =
{
new SqlParameter("strWorkShopGUID", _DDML_Confirm.strWorkShopGUID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public DDML_Confirm GetModel(DDML_ConfirmQueryCondition 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_DDML_Confirm where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DDML_Confirm _DDML_Confirm = null;
if (dt.Rows.Count > 0)
{
_DDML_Confirm = new DDML_Confirm();
DataRowToModel(_DDML_Confirm, dt.Rows[0]);
}
return(_DDML_Confirm);
}
/// <summary>
/// 添加数据
/// </summary>
public bool Add(DDML_Confirm model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_DDML_Confirm_Record");
strSql.Append("(nID,strWorkShopGUID,strWorkShopNumber,strWorkShopName,dtConfirmTime,strDutyUserNumber,strDutyUserName)");
strSql.Append("values(@nID,@strWorkShopGUID,@strWorkShopNumber,@strWorkShopName,@dtConfirmTime,@strDutyUserNumber,@strDutyUserName)");
SqlParameter[] parameters =
{
new SqlParameter("@nID", model.nID),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopNumber", model.strWorkShopNumber),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@dtConfirmTime", model.dtConfirmTime),
new SqlParameter("@strDutyUserNumber", model.strDutyUserNumber),
new SqlParameter("@strDutyUserName", model.strDutyUserName)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 保存审核记录
/// </summary>
public bool Save(DDML_Confirm _ddml_confirm)
{
DBDDML_Confirm_Record db_record = new DBDDML_Confirm_Record(this.ConnectionString);
DDML_ConfirmQueryCondition contion = new DDML_ConfirmQueryCondition();
contion.strWorkShopGUID = _ddml_confirm.strWorkShopGUID;
DDML_Confirm _existDlCF = GetModel(contion);
if (_existDlCF != null)
{
_ddml_confirm.nID = _existDlCF.nID;
Update(_ddml_confirm);
}
else
{
Add(_ddml_confirm);
}
db_record.Add(_ddml_confirm);
return(true);
}
/// <summary>
/// 添加数据
/// </summary>
public int Add(DDML_Confirm model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_DDML_Confirm");
strSql.Append("(strGUID,strWorkShopGUID,strWorkShopNumber,strWorkShopName,dtConfirmTime,strDutyUserNumber,strDutyUserName)");
strSql.Append("values(@strGUID,@strWorkShopGUID,@strWorkShopNumber,@strWorkShopName,@dtConfirmTime,@strDutyUserNumber,@strDutyUserName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", model.strGUID),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopNumber", model.strWorkShopNumber),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@dtConfirmTime", model.dtConfirmTime),
new SqlParameter("@strDutyUserNumber", model.strDutyUserNumber),
new SqlParameter("@strDutyUserName", model.strDutyUserName)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)));
}
public DDML_Confirm GetModel(string strClientGUID)
{
SqlParameter[] sqlParams =
{
new SqlParameter("strSiteGUID", strClientGUID)
};
StringBuilder strSqlOption = new StringBuilder();
//QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * ");
strSql.Append("from tab_base_Site where strSiteGUID = @strSiteGUID ");
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DDML_Confirm _DDML_Confirm = null;
if (dt.Rows.Count > 0)
{
DDML_ConfirmQueryCondition QueryCondition = new DDML_ConfirmQueryCondition();
QueryCondition.strWorkShopGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strWorkShopGUID"]);
_DDML_Confirm = GetModel(QueryCondition);
}
return(_DDML_Confirm);
}