public int LoadPartnerOrder(PartnerOrder obj)
{
string sql = @"Select
[OrderID]
,[OrderNo]
,[OrderType]
,[OutOrderNo]
,[PartnerID]
,[PartnerName]
,[CustomerID]
,[CustomerName]
,[SalesMan]
,[Address]
,[Mobile]
,[BookingDate]
,[ShipDate]
,[Status]
,[StepNo]
,[Remark]
,[AttachmentFile]
,[Created]
,[CreatedBy]
,[Modified]
,[ModifiedBy]
From [BE_PartnerOrder] With(NoLock) Where OrderID=@OrderID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pOrderID = new SqlParameter("OrderID", Convert2DBnull(obj.OrderID));
pOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pOrderID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["OrderID"]))
{
obj.OrderID = (Guid)dr["OrderID"];
}
if (!Convert.IsDBNull(dr["OrderNo"]))
{
obj.OrderNo = (string)dr["OrderNo"];
}
if (!Convert.IsDBNull(dr["OrderType"]))
{
obj.OrderType = (string)dr["OrderType"];
}
if (!Convert.IsDBNull(dr["OutOrderNo"]))
{
obj.OutOrderNo = (string)dr["OutOrderNo"];
}
if (!Convert.IsDBNull(dr["PartnerID"]))
{
obj.PartnerID = (Guid)dr["PartnerID"];
}
if (!Convert.IsDBNull(dr["PartnerName"]))
{
obj.PartnerName = (string)dr["PartnerName"];
}
if (!Convert.IsDBNull(dr["CustomerID"]))
{
obj.CustomerID = (Guid)dr["CustomerID"];
}
if (!Convert.IsDBNull(dr["CustomerName"]))
{
obj.CustomerName = (string)dr["CustomerName"];
}
if (!Convert.IsDBNull(dr["SalesMan"]))
{
obj.SalesMan = (string)dr["SalesMan"];
}
if (!Convert.IsDBNull(dr["Address"]))
{
obj.Address = (string)dr["Address"];
}
if (!Convert.IsDBNull(dr["Mobile"]))
{
obj.Mobile = (string)dr["Mobile"];
}
if (!Convert.IsDBNull(dr["BookingDate"]))
{
obj.BookingDate = (DateTime)dr["BookingDate"];
}
if (!Convert.IsDBNull(dr["ShipDate"]))
{
obj.ShipDate = (DateTime)dr["ShipDate"];
}
if (!Convert.IsDBNull(dr["Status"]))
{
obj.Status = (string)dr["Status"];
}
if (!Convert.IsDBNull(dr["StepNo"]))
{
obj.StepNo = (int)dr["StepNo"];
}
if (!Convert.IsDBNull(dr["Remark"]))
{
obj.Remark = (string)dr["Remark"];
}
if (!Convert.IsDBNull(dr["AttachmentFile"]))
{
obj.AttachmentFile = (string)dr["AttachmentFile"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
obj.CreatedBy = (string)dr["CreatedBy"];
}
if (!Convert.IsDBNull(dr["Modified"]))
{
obj.Modified = (DateTime)dr["Modified"];
}
if (!Convert.IsDBNull(dr["ModifiedBy"]))
{
obj.ModifiedBy = (string)dr["ModifiedBy"];
}
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int UpdatePartnerOrderByOrderID(PartnerOrder obj)
{
string sql = @"Update [BE_PartnerOrder] Set
[OrderNo]=@OrderNo
,[OrderType]=@OrderType
,[OutOrderNo]=@OutOrderNo
,[PartnerID]=@PartnerID
,[PartnerName]=@PartnerName
,[CustomerID]=@CustomerID
,[CustomerName]=@CustomerName
,[SalesMan]=@SalesMan
,[Address]=@Address
,[Mobile]=@Mobile
,[BookingDate]=@BookingDate
,[ShipDate]=@ShipDate
,[Status]=@Status
,[StepNo]=@StepNo
,[Remark]=@Remark
,[AttachmentFile]=@AttachmentFile
,[Created]=@Created
,[CreatedBy]=@CreatedBy
,[Modified]=@Modified
,[ModifiedBy]=@ModifiedBy
Where OrderID=@OrderID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pOrderID = new SqlParameter("OrderID", Convert2DBnull(obj.OrderID));
pOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pOrderID);
SqlParameter pOrderNo = new SqlParameter("OrderNo", Convert2DBnull(obj.OrderNo));
pOrderNo.SqlDbType = SqlDbType.VarChar;
cmd.Parameters.Add(pOrderNo);
SqlParameter pOrderType = new SqlParameter("OrderType", Convert2DBnull(obj.OrderType));
pOrderType.SqlDbType = SqlDbType.VarChar;
cmd.Parameters.Add(pOrderType);
SqlParameter pOutOrderNo = new SqlParameter("OutOrderNo", Convert2DBnull(obj.OutOrderNo));
pOutOrderNo.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pOutOrderNo);
SqlParameter pPartnerID = new SqlParameter("PartnerID", Convert2DBnull(obj.PartnerID));
pPartnerID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pPartnerID);
SqlParameter pPartnerName = new SqlParameter("PartnerName", Convert2DBnull(obj.PartnerName));
pPartnerName.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pPartnerName);
SqlParameter pCustomerID = new SqlParameter("CustomerID", Convert2DBnull(obj.CustomerID));
pCustomerID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pCustomerID);
SqlParameter pCustomerName = new SqlParameter("CustomerName", Convert2DBnull(obj.CustomerName));
pCustomerName.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCustomerName);
SqlParameter pSalesMan = new SqlParameter("SalesMan", Convert2DBnull(obj.SalesMan));
pSalesMan.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pSalesMan);
SqlParameter pAddress = new SqlParameter("Address", Convert2DBnull(obj.Address));
pAddress.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pAddress);
SqlParameter pMobile = new SqlParameter("Mobile", Convert2DBnull(obj.Mobile));
pMobile.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMobile);
SqlParameter pBookingDate = new SqlParameter("BookingDate", Convert2DBnull(obj.BookingDate));
pBookingDate.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pBookingDate);
SqlParameter pShipDate = new SqlParameter("ShipDate", Convert2DBnull(obj.ShipDate));
pShipDate.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pShipDate);
SqlParameter pStatus = new SqlParameter("Status", Convert2DBnull(obj.Status));
pStatus.SqlDbType = SqlDbType.Char;
cmd.Parameters.Add(pStatus);
SqlParameter pStepNo = new SqlParameter("StepNo", Convert2DBnull(obj.StepNo));
pStepNo.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pStepNo);
SqlParameter pRemark = new SqlParameter("Remark", Convert2DBnull(obj.Remark));
pRemark.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pRemark);
SqlParameter pAttachmentFile = new SqlParameter("AttachmentFile", Convert2DBnull(obj.AttachmentFile));
pAttachmentFile.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pAttachmentFile);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.VarChar;
cmd.Parameters.Add(pCreatedBy);
SqlParameter pModified = new SqlParameter("Modified", Convert2DBnull(obj.Modified));
pModified.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pModified);
SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", Convert2DBnull(obj.ModifiedBy));
pModifiedBy.SqlDbType = SqlDbType.VarChar;
cmd.Parameters.Add(pModifiedBy);
return(cmd.ExecuteNonQuery());
}