//查询多个（查ID）
public int Select(ref List<M_Purchase> Obj, List<int> ID, ref string ErrMsg)
{
SqlConnection conn;
using (conn = CreatConn())
{
SqlCommand cmd = new SqlCommand($"select ID,Agent_ID,Audit_BL,DocumentNumber,CompanyName,PurchaseDate,Status,InvoicePrice,UnInvoicePrice,TotalPrice from {TableName} where ID = @ID", conn);
SqlDataReader sdr;
SqlParameter par = new SqlParameter("@ID", SqlDbType.Int);
cmd.Parameters.Add(par);
int tmpOut = 0;
try
{
conn.Open();
foreach (int i in ID)
{
cmd.Parameters["@ID"].Value = i;
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
M_Purchase TmpObj = new M_Purchase();
TmpObj.ID = (int)sdr["ID"];
TmpObj.Agent_ID = (int)sdr["Agent_ID"];
TmpObj.Audit_BL = (int)sdr["Audit_BL"];
TmpObj.CompanyName = (string)sdr["CompanyName"];
TmpObj.DocumentNumber = (string)sdr["DocumentNumber"];
TmpObj.InvoicePrice = (float)sdr["InvoicePrice"];
TmpObj.PurchaseDate = (DateTime)sdr["PurchaseDate"];
TmpObj.Status = (int)sdr["Status"];
TmpObj.TotalPrice = (float)sdr["TotalPrice"];
TmpObj.UnInvoicePrice = (float)sdr["UnInvoicePrice"];
Obj.Add(TmpObj);
tmpOut++;
}
sdr.Close();
}
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return -1;
}
finally
{
cmd.Dispose();
}
if (ID.Count() == tmpOut)
{
return 1;
}
else
{
return -1;
}
}
}
//查询单个（查ID）
public int Select(ref M_Purchase Obj, int ID, ref string ErrMsg)
{
SqlConnection conn;
using (conn = CreatConn())
{
SqlCommand cmd = new SqlCommand($"select ID,Agent_ID,Audit_BL,DocumentNumber,CompanyName,PurchaseDate,Status,InvoicePrice,UnInvoicePrice,TotalPrice from {TableName} where ID = {ID}", conn);
SqlDataReader sdr;
try
{
conn.Open();
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Obj.ID = (int)sdr["ID"];
Obj.Agent_ID = (int)sdr["Agent_ID"];
Obj.Audit_BL = (int)sdr["Audit_BL"];
Obj.CompanyName = (string)sdr["CompanyName"];
Obj.DocumentNumber = (string)sdr["DocumentNumber"];
Obj.InvoicePrice = (float)sdr["InvoicePrice"];
Obj.PurchaseDate = (DateTime)sdr["PurchaseDate"];
Obj.Status = (int)sdr["Status"];
Obj.TotalPrice = (float)sdr["TotalPrice"];
Obj.UnInvoicePrice = (float)sdr["UnInvoicePrice"];
return 1;
}
return -1;
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return -1;
}
finally
{
cmd.Dispose();
}
}
}
//更新单个（查ID）
public int Update(M_Purchase Obj, ref string ErrMsg)
{
SqlConnection conn;
using (conn = CreatConn())
{
SqlCommand cmd = new SqlCommand($"update {TableName} set Agent_ID = @Agent_ID, Audit_BL = @Audit_BL, DocumentNumber = @DocumentNumber, CompanyName = @CompanyName, PurchaseDate = @PurchaseDate, Status = @Status, InvoicePrice = @InvoicePrice, UnInvoicePrice = @UnInvoicePrice, TotalPrice = @TotalPrice where ID = @ID", conn);
SqlParameter par = new SqlParameter("@Agent_ID", SqlDbType.Int);
par.Value = Obj.Agent_ID;
cmd.Parameters.Add(par);
par = new SqlParameter("@Audit_BL", SqlDbType.Int);
par.Value = Obj.Audit_BL;
cmd.Parameters.Add(par);
par = new SqlParameter("@DocumentNumber", SqlDbType.Char, 50);
par.Value = Obj.DocumentNumber;
cmd.Parameters.Add(par);
par = new SqlParameter("@CompanyName", SqlDbType.Char, 100);
par.Value = Obj.CompanyName;
cmd.Parameters.Add(par);
par = new SqlParameter("@PurchaseDate", SqlDbType.DateTime);
par.Value = Obj.PurchaseDate;
cmd.Parameters.Add(par);
par = new SqlParameter("@Status", SqlDbType.Int);
par.Value = Obj.Status;
cmd.Parameters.Add(par);
par = new SqlParameter("@InvoicePrice", SqlDbType.Float);
par.Value = Obj.InvoicePrice;
cmd.Parameters.Add(par);
par = new SqlParameter("@UnInvoicePrice", SqlDbType.Float);
par.Value = Obj.UnInvoicePrice;
cmd.Parameters.Add(par);
par = new SqlParameter("@TotalPrice", SqlDbType.Float);
par.Value = Obj.TotalPrice;
cmd.Parameters.Add(par);
par = new SqlParameter("@ID", SqlDbType.Int);
par.Value = Obj.ID;
cmd.Parameters.Add(par);
try
{
conn.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return 1;
}
else
{
return -1;
}
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return -1;
}
finally
{
cmd.Dispose();
}
}
}
//插入单个
public int Insert(ref M_Purchase Obj, ref string ErrMsg)
{
SqlConnection conn;
using (conn = CreatConn())
{
SqlCommand cmd = new SqlCommand($"insert into {TableName} (Agent_ID,Audit_BL,DocumentNumber,CompanyName,PurchaseDate,Status,InvoicePrice,UnInvoicePrice,TotalPrice) values (@Agent_ID,@Audit_BL,@DocumentNumber,@CompanyName,@PurchaseDate,@Status,@InvoicePrice,@UnInvoicePrice,@TotalPrice);select @@IDENTITY as int", conn);
SqlParameter par = new SqlParameter("@Agent_ID", SqlDbType.Int);
par.Value = Obj.Agent_ID;
cmd.Parameters.Add(par);
par = new SqlParameter("@Audit_BL", SqlDbType.Int);
par.Value = Obj.Audit_BL;
cmd.Parameters.Add(par);
par = new SqlParameter("@DocumentNumber", SqlDbType.Char, 50);
par.Value = Obj.DocumentNumber;
cmd.Parameters.Add(par);
par = new SqlParameter("@CompanyName", SqlDbType.Char, 100);
par.Value = Obj.CompanyName;
cmd.Parameters.Add(par);
par = new SqlParameter("@PurchaseDate", SqlDbType.DateTime);
par.Value = Obj.PurchaseDate;
cmd.Parameters.Add(par);
par = new SqlParameter("@Status", SqlDbType.Int);
par.Value = Obj.Status;
cmd.Parameters.Add(par);
par = new SqlParameter("@InvoicePrice", SqlDbType.Float);
par.Value = Obj.InvoicePrice;
cmd.Parameters.Add(par);
par = new SqlParameter("@UnInvoicePrice", SqlDbType.Float);
par.Value = Obj.UnInvoicePrice;
cmd.Parameters.Add(par);
par = new SqlParameter("@TotalPrice", SqlDbType.Float);
par.Value = Obj.TotalPrice;
cmd.Parameters.Add(par);
try
{
conn.Open();
decimal d = (decimal)cmd.ExecuteScalar();
Obj.ID = (int)d;
if (Obj.ID > 0)
{
return 1;
}
else
{
return -1;
}
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return -1;
}
finally
{
cmd.Dispose();
}
}
}
//查询单个（查ID）
public static int Select(ref M_Purchase Obj, int ID, ref string ErrMsg)
{
I_Purchase I = (D_Purchase)SimpleFactory.CreateObject(DBType.Purchase);
return I.Select(ref Obj, ID, ref ErrMsg);
}
//更新单个（查ID）
public static int Update(M_Purchase Obj, ref string ErrMsg)
{
I_Purchase I = (D_Purchase)SimpleFactory.CreateObject(DBType.Purchase);
return I.Update(Obj, ref ErrMsg);
}