/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private EmsModel.EquipDetail GetEmsModel(DbDataReader dr)
{
EmsModel.EquipDetail EmsModel = new EmsModel.EquipDetail();
DbDataReaderToModel(EmsModel, dr);
return(EmsModel);
}
/// <summary>
/// 根据条形码得到一个对象实体
/// </summary>
public EmsModel.EquipDetail GetModelByBarcode(string ID)
{
StringBuilder sbSql4org;
DbParameter[] parms4org;
sbSql4org = new StringBuilder();
sbSql4org.Append("SELECT * FROM EquipDetail");
sbSql4org.Append(" WHERE Barcode=@in_Barcode");
EmsModel.EquipDetail model = new EmsModel.EquipDetail();
parms4org = new DbParameter[] {
dbHelper.CreateInDbParameter("@in_Barcode", DbType.String, ID)
};
using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, sbSql4org.ToString(), parms4org))
{
if (dr.Read())
{
DbDataReaderToModel(model, dr);
return(model);
}
return(null);
}
}
public void AddConsume(HttpContext context)
{
string callback = context.Request["jsoncallback"];
string name = context.Request["name"];
byte type = Convert.ToByte(HttpContext.Current.Request["type"]);
int result;
if (new EmsBLL.EquipDetail().IsInsEpExists(name, type))
{
result = -1;
}
else
{
string useridcard = context.Request["useridcard"];
int count = Convert.ToInt32(context.Request["count"]);
string unit = context.Request["unit"];
string remarks = context.Request["remarks"];
EmsModel.EquipDetail insEp = new EmsModel.EquipDetail();
insEp.AssetNumber = "";
insEp.AssetName = name;
insEp.Count = count;
insEp.Unit = unit;
insEp.Type = type;
insEp.EquipSource = 0;//0本院资产;1资产系统
insEp.IsConsume = 1;
insEp.Remarks = remarks;
insEp.Creator = useridcard;
insEp.CreateTime = DateTime.Now;
insEp.IsDelete = 0;
insEp.UseStatus = 0;
insEp.EquipKindId = 0;
insEp.EquipIntoID = 0;
insEp.EquipStatus = 0;
insEp.Barcode = "";
insEp.ClassNumber = "";
insEp.AssetsClassName = name;
insEp.IntlClassCode = "";
insEp.IntlClassName = "";
insEp.UsageStatus = "";
insEp.UsageDirection = "";
insEp.JYBBBSYFX = "";
insEp.AcquisitionMethod = "";
insEp.AcquisitionDate = DateTime.Now;
insEp.BrandStandardModel = "";
insEp.EquipmentUse = "";
insEp.UseDepartment = "";
insEp.UsePeople = "";
insEp.Factory = "";
insEp.StorageLocation = "0";
insEp.WorthType = "";
insEp.UseNature = "";
insEp.Worth = 0;
insEp.FinanceRecordType = "";
insEp.FundsSubject = "";
insEp.CountryCode = "";
insEp.Operator = useridcard;
insEp.FinanceRecordType = "";
insEp.FinanceRecordType = "";
insEp.FinanceRecordType = "";
insEp.ManualModify = 0;
result = new EmsBLL.EquipDetail().Add(insEp);
}
//输出Json
HttpContext.Current.Response.Write(callback + "({\"result\":" + result + "})");
HttpContext.Current.Response.End();
}
