public DataTable CheckStoreCode(AddEmployeeParam addEmployeeParam)
{
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(EmployeeSql.SELECT_T_BUSS_STORE_CODE_BY_STORE_CODE, addEmployeeParam.storeCode);
string select = selectBuilder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0];
return(dt);
}
public AddEmployeeParam CheckOldStoreId(string shopId)
{
AddEmployeeParam msg = new AddEmployeeParam();
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(EmployeeSql.SELECT_T_BUSS_STORE_CODE_BY_STORE_ID, shopId);
string select = selectBuilder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0];
if (dt.Rows.Count > 0)
{
msg.storeCode = dt.Rows[0]["store_code"].ToString();
msg.state = dt.Rows[0]["state"].ToString();
}
return(msg);
}
public bool UpdateT_buss_store_code(AddEmployeeParam addEmployeeParam, string shopId)
{
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(EmployeeSql.UPDATE_T_BUSS_STORE_CODE, addEmployeeParam.storeCode, addEmployeeParam.state, shopId);
string select = selectBuilder.ToString();
if (DatabaseOperationWeb.ExecuteDML(select))
{
return(true);
}
else
{
return(false);
}
}
