ReturnMsg SetDepartmentCode(sysdatdepartment model)
{
if (string.IsNullOrWhiteSpace(model.ParentCode))
{
model.ParentCode = "0";
}
if (model != null)
{
string maxCode = string.Empty;
string maxCodeSql = "select CONCAT('00',max(c.DepartID)+1) maxcode from sysdatdepartment c where c.ParentCode=@parentcode;";
CmdParameter[] maxCodeparas = new CmdParameter[1];
maxCodeparas[0] = new CmdParameter()
{
DBtype = DBType.String, ParameterName = "@parentcode", Value = model.ParentCode
};
DataSet ds = new BaseSQL(sqlConn).QuserDs(maxCodeSql, maxCodeparas);
if (ds.Tables[0].Rows.Count > 0)
{
var row = ds.Tables[0].Rows[0];
maxCode = row["maxcode"] != DBNull.Value ? row["maxcode"].ToString() : (model.ParentCode + "001");
}
else
{
Fail("未查询到数据表sysdatdepartment对应的parentCode数据");
}
model.DepartID = maxCode;
bool flag = AddBysql <sysdatdepartment>(model);
if (flag)
{
Success();
}
else
{
Fail($"插入数据表sysdatdepartment失败！");
}
}
return(resultData);
}
public ReturnMsg AutoSetEquipmentSpecieCodeTest(string sqlConn, sysdatdepartment sysdatdepartment)
{
this.sqlConn = sqlConn;
//equipmentspecieModel = JsonConvert.DeserializeObject<Sfcdatequipmentspecies>(Parameter.ToString());
return(SetDepartmentCode(sysdatdepartment));
}
