public EntityComputationUnit GetComputationUnit(string cComUnitName) { EntityComputationUnit entity = new EntityComputationUnit(); string sql = @"select cComUnitCode,cGroupCode from ComputationUnit where cComUnitName=@cComUnitName"; SqlParameter[] para = { new SqlParameter("@cComUnitName", cComUnitName), }; DataTable dt = DB_SqlHelper.ExecuteDataTable(sql, para); if (dt != null && dt.Rows.Count > 0) { entity.cComUnitCode = dt.Rows[0]["cComUnitCode"].ToString(); entity.cGroupCode = dt.Rows[0]["cGroupCode"].ToString(); } return(entity); }
public string AddInventory(string UserCode, string PlainPassword, string StrAccID, int AccYear, string Act, EntityInventory entity, out int success) { success = 0; #region 验证 // 字段必填项验证 string msg = ""; if (!entity.CheckEntity(out msg)) { return(msg); } if (string.IsNullOrWhiteSpace(GetInventoryClass(entity.cInvCCode, true))) { return(string.Format("U8中不存在存货分类编码或非末级:{0}!", entity.cInvCCode)); } EntityComputationUnit unit = new EntityComputationUnit(); unit = GetComputationUnit(entity.cComUnitCode); if (string.IsNullOrWhiteSpace(unit.cComUnitCode)) { return(string.Format("U8中没有维护计量单位:{0}!", entity.cComUnitCode)); } #endregion entity.cComUnitCode = unit.cComUnitCode; entity.cGroupCode = unit.cGroupCode; entity.cMaker = GetUserName(UserCode); entity.bBarCode = string.IsNullOrWhiteSpace(entity.cBarCode) ? 0 : 1; entity.cValueType = string.IsNullOrWhiteSpace(entity.cValueType) ? "全月平均法" : entity.cValueType; string id = ""; if (!string.IsNullOrWhiteSpace(GetInventory(entity.cInvCode))) { id = UpdateInventory(entity); } else { id = InsertInventory(entity); } success = string.IsNullOrWhiteSpace(id) ? 0 : 1; return(id); }