public FeedbackInfomation QueryStocktakingBillDetailsInfo(long stocktakingId)
{
FeedbackInfomation fi = new FeedbackInfomation();
try
{
DataSet ds = MySMDAL.SelectStocktakingDetails(stocktakingId);
if (DataValidate.CheckDataSetNotEmpty(ds))
{
fi.Result = ds;
fi.FeedbackMessage = "";
fi.ErrorStatus = STATUS_ADAPTER.QUERY_NORMAL;
}
else
{
fi.Result = null;
fi.FeedbackMessage = Tips.QERUY_RESULT_EMPTY;
fi.ErrorStatus = STATUS_ADAPTER.QUERY_NODATA;
}
return(fi);
}
catch (Exception ex)
{
fi.Result = null;
fi.FeedbackMessage = Tips.QUERY_FAILED + ":" + ex.Message.ToString();
fi.ErrorStatus = STATUS_ADAPTER.QUERY_ERROR;
return(fi);
}
}
public bool CheckedOperatorAccountRepeate(string account, int operatorId)
{
DataSet ds = SqlDataHelper.ExecuteDataSet(SqlDataHelper.GetConnection(), "Operator_View_Check", account, operatorId);
if (DataValidate.CheckDataSetNotEmpty(ds))
{
return(true);
}
return(false);
}
private bool CheckCmstID(int cmstId)
{
if (DataValidate.CheckDataSetNotEmpty(MyOrganizationDAL.SelectOrganizationByCmstId(cmstId)))
{
return(true);
}
else
{
return(false);
}
}
private bool CheckCmstName(string cmstName)
{
if (DataValidate.CheckDataSetNotEmpty(MyOrganizationDAL.SelectOrganizationByCmstName(cmstName)))
{
return(true);
}
else
{
return(false);
}
}
public StockModel SelectStocktakingBill(int cmstId, long Id, SqlTransaction st)
{
string sqlstr = $" select * from StocktakingView where StackingBillID = {Id} and CmstID = {cmstId} ";
DataSet ds = SqlDataHelper.ExecuteDataSet(st, CommandType.Text, sqlstr);
if (DataValidate.CheckDataSetNotEmpty(ds))
{
return(DrToStocktakingBill(ds.Tables[0].Rows[0]));
}
return(null);
}
public DataSet SelectAllMenu()
{
string sqlstr = "select * from dbo.Menu";
DataSet ds = SqlDataHelper.ExecuteDataSet(SqlDataHelper.GetConnection(), CommandType.Text, sqlstr);
if (DataValidate.CheckDataSetNotEmpty(ds))
{
return(ds);
}
return(null);
}
public OutboundWayEntity DsToOutboundWayEntity(DataSet ds)
{
OutboundWayEntity oe = new OutboundWayEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
var dr = ds.Tables[0].Rows[0];
oe.OwaId = Convert.ToInt32(dr["Owa_Id"]);
oe.OwaName = dr["Owa_Name"].ToString();
oe.OwaRemark = dr["Owa_Remark"].ToString();
oe.OwaIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Owa_IfUse"]) == true ? false : dr["Owa_IfUse"]);
oe.OwaIfUse2 = Convert.ToBoolean(dr["Owa_IfUse"]) == true ? "是" : "否";
}
return(oe);
}
public MeasureWayEntity DsToMeasureWayEntity(DataSet ds)
{
MeasureWayEntity me = new MeasureWayEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
var dr = ds.Tables[0].Rows[0];
me.MwaId = Convert.ToInt32(dr["Mwa_Id"]);
me.MwaName = dr["Mwa_Name"].ToString();
me.MwaRemark = dr["Mwa_Remark"].ToString();
me.MwaIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Mwa_IfUse"]) == true ? false : dr["Mwa_IfUse"]);
me.MwaIfUse2 = Convert.ToBoolean(dr["Mwa_IfUse"]) == true ? "是" : "否";
}
return(me);
}
public int SelectStocktakingStatus(long stocktakingId, int status, SqlTransaction st)
{
string sqlstr = $" select Count(Sb_Id) from StocktakingBill where Sb_Id = {stocktakingId} and Sb_Status = {status} ";
DataSet ds = SqlDataHelper.ExecuteDataSet(st, CommandType.Text, sqlstr);
if (DataValidate.CheckDataSetNotEmpty(ds))
{
int ret = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
if (ret > 0)
{
return(ret);
}
}
return(-1);
}
public RateTypeEntity DsToRateTypeEntity(DataSet ds)
{
RateTypeEntity rte = new RateTypeEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
var dr = ds.Tables[0].Rows[0];
rte.RtyId = Convert.ToInt32(dr["Rty_Id"]);
rte.RtyName = dr["Rty_Name"].ToString();
rte.RtyRemark = dr["Rty_Remark"].ToString();
rte.RtyIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Rty_IfUse"]) == true ? false : dr["Rty_IfUse"]);
rte.RtyIfUse2 = Convert.ToBoolean(dr["Rty_IfUse"]) == true ? "是" : "否";
}
return(rte);
}
public DepotsPropertyEntity DsToDepotsPropertyEntity(DataSet ds)
{
DepotsPropertyEntity de = new DepotsPropertyEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
var dr = ds.Tables[0].Rows[0];
de.DprId = Convert.ToInt32(dr["Dpr_Id"]);
de.DprName = dr["Dpr_Name"].ToString();
de.DprRemark = dr["Dpr_Remark"].ToString();
de.DprIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Dpr_IfUse"]) == true ? false : dr["Dpr_IfUse"]);
de.DprIfUse2 = Convert.ToBoolean(dr["Dpr_IfUse"]) == true ? "是" : "否";
}
return(de);
}
public OrganizationEntity DsToOrganizationEntity(DataSet ds)
{
OrganizationEntity oe = new OrganizationEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
oe.CmstID = Convert.ToInt32(dr["Cmst_ID"]);
oe.CmstName = dr["Cmst_Name"].ToString();
oe.CmstIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Cmst_IfUse"]) == true ? false : dr["Cmst_IfUse"]);
oe.CmstState = Convert.IsDBNull(dr["Cmst_IfUse"]) == true ? "是" : "否";
}
}
return(oe);
}
public List <RoleOperations> DsToOperationList(DataSet ds)
{
List <RoleOperations> rops = new List <RoleOperations>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
RoleOperations rop = new RoleOperations();
rop.OperationID = Convert.ToInt32(dr["Ope_ID"]);
rop.OperationName = dr["Ope_Name"].ToString();
rops.Add(rop);
}
}
return(rops);
}
public int SelectStocktakingBillDetaisCount(long stocktakingId, int status, SqlTransaction st)
{
StringBuilder sqlsb = new StringBuilder($" select count(Sbd_Id) from StocktakingBillDetail where Sbd_sb_id = {stocktakingId} ");
if (status > 0)
{
sqlsb.Append($" and Sbd_Status = {status} ");
}
DataSet ds = SqlDataHelper.ExecuteDataSet(st, CommandType.Text, sqlsb.ToString());
if (DataValidate.CheckDataSetNotEmpty(ds))
{
return(Convert.ToInt32(ds.Tables[0].Rows[0][0]));
}
return(-1);
}
public List <BillStatus> DsToBillStatusList(DataSet ds)
{
List <BillStatus> bses = new List <BillStatus>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
BillStatus bs = new BillStatus();
bs.BillStatusId = Convert.ToInt32(dr["BillStatus_Id"]);
bs.BillStatusName = dr["BillStatus_Name"].ToString();
bses.Add(bs);
}
}
return(bses);
}
public long InsertStocktakingBill(StockModel sb, SqlTransaction st)
{
MessageBox.Show("山映斜阳天接水，芳草无情，更在斜阳外！！！");
string sqlstr = $" insert into StocktakingBill ( Sb_Cmst_ID, Sb_Dep_ID, Sb_Rar_Id, Sb_Com_ID, Sb_Ope_Maker, Sb_MakeTime, Sb_Status) values ({sb.CmstID},{(sb.DepotID == null ? "NULL" : sb.DepotID.ToString())},{(sb.ReservoirID == null ? "NULL" : sb.ReservoirID.ToString())},{(sb.CompanyID == null ? "NULL" : sb.CompanyID.ToString())},{sb.Maker},getdate(),{sb.Status});select @@Identity;";
DataSet ds = SqlDataHelper.ExecuteDataSet(st, CommandType.Text, sqlstr);
long ret = -1;
if (DataValidate.CheckDataSetNotEmpty(ds))
{
ret = Convert.ToInt64(ds.Tables[0].Rows[0][0] ?? -1);
return(ret);
}
else
{
throw new Exception(INSERT_STOCKTAKINGBILL_ERROR);
}
}
public List <OperationEntity> DsToOperationList(DataSet ds)
{
List <OperationEntity> oes = new List <OperationEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
OperationEntity oe = new OperationEntity();
oe.OperationID = Convert.ToInt32(dr["Ope_ID"]);
oe.OperateName = dr["Ope_Name"].ToString();
oe.CsyID = Convert.ToInt32(dr["Csy_ID"]);
oe.MenuID = Convert.ToInt32(dr["Ope_Meu_ID"]);
oe.OperateUrl = dr["Ope_Url"].ToString();
oes.Add(oe);
}
return(oes);
}
private List <SignType> DsToSignTypeEntityList(DataSet ds)
{
if (DataValidate.CheckDataSetNotEmpty(ds))
{
List <SignType> sts = new List <SignType>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
sts.Add(new SignType
{
SignTypeID = Convert.ToInt32(dr[SignTypeTab.STY_ID]),
SignTypeName = dr[SignTypeTab.STY_NAME].ToString()
});
}
return(sts);
}
return(null);
}
public OperationEntity DsToOperationEntity(DataSet ds)
{
OperationEntity oe = new OperationEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
oe.OperationID = Convert.ToInt32(dr["Ope_ID"]);
oe.OperateName = dr["Ope_Name"].ToString();
oe.CsyID = Convert.ToInt32(dr["Csy_ID"]);
oe.MenuID = Convert.ToInt32(dr["Ope_Meu_ID"]);
oe.OperateUrl = dr["Ope_Url"].ToString();
}
}
return(oe);
}
private List <BillType> DsToBillTypeEntity(DataSet ds)
{
if (DataValidate.CheckDataSetNotEmpty(ds))
{
List <BillType> Bes = new List <BillType>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BillType Bte = new BillType
{
BillTypeID = Convert.ToInt32(dr[BillTypeTab.BTY_ID]),
BillTypeName = dr[BillTypeTab.BTY_NAME].ToString(),
};
Bes.Add(Bte);
}
return(Bes);
}
return(null);
}
public List <MenuEntity> DsToMenuList(DataSet ds)
{
List <MenuEntity> mes = new List <MenuEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
MenuEntity me = new MenuEntity();
me.MenuID = Convert.ToInt32(dr["Meu_ID"]);
me.MenuName = dr["Meu_Menu"].ToString();
me.CsyID = Convert.ToInt32(dr["Csy_ID"]);
me.FatherID = Convert.ToInt32(dr["Meu_FatherMenuID"]);
me.Rank = Convert.ToInt32(dr["Meu_Rank"]);
me.Url = dr["Meu_Url"].ToString();
mes.Add(me);
}
return(mes);
}
public MenuEntity DsToMenuEntity(DataSet ds)
{
MenuEntity me = new MenuEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
me.MenuID = Convert.ToInt32(dr["Meu_ID"]);
me.MenuName = dr["Meu_Menu"].ToString();
me.CsyID = Convert.ToInt32(dr["Csy_ID"]);
me.FatherID = Convert.ToInt32(dr["Meu_FatherMenuID"]);
me.Rank = Convert.ToInt32(dr["Meu_Rank"]);
me.Url = dr["Meu_Url"].ToString();
}
}
return(me);
}
public List <RateTypeEntity> DsToRateTypeEntityList(DataSet ds)
{
List <RateTypeEntity> rtes = new List <RateTypeEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
RateTypeEntity rte = new RateTypeEntity();
rte.RtyId = Convert.ToInt32(dr["Rty_Id"]);
rte.RtyName = dr["Rty_Name"].ToString();
rte.RtyRemark = dr["Rty_Remark"].ToString();
rte.RtyIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Rty_IfUse"]) == true ? false : dr["Rty_IfUse"]);
rte.RtyIfUse2 = Convert.ToBoolean(dr["Rty_IfUse"]) == true ? "是" : "否";
rtes.Add(rte);
}
}
return(rtes);
}
public List <MeasureWayEntity> DsToMeasureWayEntityList(DataSet ds)
{
List <MeasureWayEntity> mes = new List <MeasureWayEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
MeasureWayEntity me = new MeasureWayEntity();
me.MwaId = Convert.ToInt32(dr["Mwa_Id"]);
me.MwaName = dr["Mwa_Name"].ToString();
me.MwaRemark = dr["Mwa_Remark"].ToString();
me.MwaIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Mwa_IfUse"]) == true ? false : dr["Mwa_IfUse"]);
me.MwaIfUse2 = Convert.ToBoolean(dr["Mwa_IfUse"]) == true ? "是" : "否";
mes.Add(me);
}
}
return(mes);
}
public List <DepotsPropertyEntity> DsToDepotsPropertyEntityList(DataSet ds)
{
List <DepotsPropertyEntity> des = new List <DepotsPropertyEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
DepotsPropertyEntity de = new DepotsPropertyEntity();
de.DprId = Convert.ToInt32(dr["Dpr_Id"]);
de.DprName = dr["Dpr_Name"].ToString();
de.DprRemark = dr["Dpr_Remark"].ToString();
de.DprIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Dpr_IfUse"]) == true ? false : dr["Dpr_IfUse"]);
de.DprIfUse2 = Convert.ToBoolean(dr["Dpr_IfUse"]) == true ? "是" : "否";
des.Add(de);
}
}
return(des);
}
public List <OutboundWayEntity> DsToOutboundWayEntityList(DataSet ds)
{
List <OutboundWayEntity> oes = new List <OutboundWayEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
OutboundWayEntity oe = new OutboundWayEntity();
oe.OwaId = Convert.ToInt32(dr["Owa_Id"]);
oe.OwaName = dr["Owa_Name"].ToString();
oe.OwaRemark = dr["Owa_Remark"].ToString();
oe.OwaIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Owa_IfUse"]) == true ? false : dr["Owa_IfUse"]);
oe.OwaIfUse2 = Convert.ToBoolean(dr["Owa_IfUse"]) == true ? "是" : "否";
oes.Add(oe);
}
}
return(oes);
}
private List <Subject> DsToSubjectEntityList(DataSet ds)
{
if (DataValidate.CheckDataSetNotEmpty(ds))
{
List <Subject> Ses = new List <Subject>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
Subject se = new Subject
{
SubjectID = Convert.ToInt32(dr["Sub_Id"]),
SubjectName = dr["Sub_Name"].ToString(),
SubjectType = Convert.ToBoolean(dr["Sub_Type"])
};
Ses.Add(se);
}
return(Ses);
}
return(null);
}
public List <OrganizationEntity> DsToOrganizationEntityList(DataSet ds)
{
List <OrganizationEntity> Oes = new List <OrganizationEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrganizationEntity oe = new OrganizationEntity();
oe.CmstID = Convert.ToInt32(dr["Cmst_ID"]);
oe.CmstName = dr["Cmst_Name"].ToString();
oe.CmstSysAccount = dr["Ope_Account"].ToString();
oe.CmstIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Cmst_IfUse"]) == true ? false : dr["Cmst_IfUse"]);
oe.CmstState = Convert.ToBoolean(dr["Cmst_IfUse"]) == true ? "是" : "否";
Oes.Add(oe);
}
}
return(Oes);
}
public StocktakingBillDetail SelectStocktakingBillDetail(long stocktakingDetailId, SqlTransaction st = null)
{
string sqlstr = $" select * from StocktakingDetailInfo where StocktakingDetailID = {stocktakingDetailId} ";
DataSet ds;
if (st == null)
{
ds = SqlDataHelper.ExecuteDataSet(SqlDataHelper.GetConnection(), CommandType.Text, sqlstr);
}
else
{
ds = SqlDataHelper.ExecuteDataSet(st, CommandType.Text, sqlstr);
}
if (DataValidate.CheckDataSetNotEmpty(ds))
{
return(DrToStocktakingBillDetail(ds.Tables[0].Rows[0]));
}
return(null);
}
public RoleEntity InsertRoleEtity(RoleEntity re)
{
try
{
DataSet ds = SqlDataHelper.ExecuteDataSet(SqlDataHelper.GetConnection(), "Role_Insert", re.CmstID, re.CsyID, re.RoleName, re.Remark, re.IfUse == true ? 1 : 0);
if (DataValidate.CheckDataSetNotEmpty(ds))
{
re.RoleID = Convert.ToInt32(ds.Tables[0].Rows[0]["Rol_ID"]);
return(re);
}
else
{
throw new Exception("插入角色失败");
}
}
catch (Exception ex)
{
throw ex;
}
}
