private object LoadTransferForm(long HeaderId)
{
ReportDocument rptDoc = ReportFactory.GetReport();
header = PartTransferDAO.GetTransferHeader(HeaderId);
if (header != null)
{
rptDoc.Load(HttpContext.Current.Server.MapPath(@"~/Part/Report/Crystal/StockTransferReport.rpt"));
IList<PartTransfer> data = header.TransferDetails.Select(td => new PartTransfer(td)).ToList();
rptDoc.SetDataSource(data);
string comment = header.TransferComment;
if (comment == null) comment = "";
string dealer = header.Dealer.DealerName;
string saleman = string.IsNullOrEmpty(UserHelper.Fullname) ? UserHelper.Username : UserHelper.Fullname;
string sheet = string.IsNullOrEmpty(header.VoucherNumber) ? "" : header.VoucherNumber;
rptDoc.SetParameterValue("TransferDate", header.TransferDate);
rptDoc.SetParameterValue("Comment", comment);
rptDoc.SetParameterValue("FromWarehouse", header.Warehouse.Address);
rptDoc.SetParameterValue("ToWarehouse", header.Warehouse1.Address);
rptDoc.SetParameterValue("SheetNo", sheet);
rptDoc.SetParameterValue("Dealer", dealer);
rptDoc.SetParameterValue("SaleMan", saleman);
}
return rptDoc;
}
public void Delete(TransferHeader ob)
{
if (IsExist(ob.TransferNo))
{
db.TransferHeader.Remove(ob);
}
}
private ActionResult ViewDetail(TransferHeader ob, string msg, AlertMsgType?msgType)
{
try
{
if (ob == null)
{
throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง");
}
if (!string.IsNullOrWhiteSpace(msg))
{
WidgetAlertModel alert = new WidgetAlertModel()
{
Message = msg
};
if (msgType.HasValue)
{
alert.Type = msgType.Value;
}
ViewBag.Alert = alert;
}
AccountPermission permission = new AccountPermission();
if (ob.JobOrder != null)
{
ob.JobOrder.Team = uow.Modules.TeamOperation.Get(ob.JobOrder.TeamId.HasValue ? ob.JobOrder.TeamId.Value : 0);
permission = GetPermissionOperation(CurrentUID, ob.JobOrder.Team);
}
else
{
List <TeamOperation> manager = uow.Modules.TeamOperation.Manager(CurrentUID);
if (manager != null)
{
permission.IsManager = true;
permission.IsEdit = true;
permission.IsTeam = true;
permission.IsAdminTeam = false;
}
}
ViewData["optCustomer"] = uow.Modules.Customer.GetAllAddress();
ViewData["optCustomerAddress"] = uow.Modules.CustomerAddress.Gets();
ViewData["optProduct"] = uow.Modules.Product.Gets();
ViewData["optContact"] = uow.Modules.CustomerContact.Gets();
ViewData["optEmployee"] = uow.Modules.Employee.Gets();
ViewData["optPermission"] = permission;
return(View(ob));
}
catch (Exception ex)
{
return(RedirectToAction("Index", MVCController, new
{
area = MVCArea,
msg = ex.GetMessage(),
msgType = AlertMsgType.Danger
}));
}
}
public void SetIn(TransferHeader ob)
{
TrasferIntHeaderAdd(ob);
/* if (ob.TransferId == 0)
* { db.TransferHeader.Add(ob); }
* else { db.Entry(ob).State = EntityState.Modified; }*/
}
/// <summary>
/// Initialize a transfer header
/// </summary>
/// <param name="header">Header reference to initialize</param>
public static void InitTransferHeader(ref TransferHeader header)
{
header.FormatCode = Consts.FormatCode;
header.NumPackets = 0;
header.ProtocolVersion = Consts.ProtocolVersion;
header.SequenceNumber = 0;
header.DataLength = 0;
header.ChecksumData = 0;
header.ChecksumHeader = 0;
}
public void TransferHeader()
{
Span <byte> blob = GetBlob("transferHeader.bin");
TransferHeader header = MemoryMarshal.Read <TransferHeader>(blob);
// Header
Assert.AreEqual(Consts.FormatCode, header.FormatCode);
Assert.AreEqual(4, header.NumPackets);
Assert.AreEqual(Consts.ProtocolVersion, header.ProtocolVersion);
Assert.AreEqual(12345, header.SequenceNumber);
Assert.AreEqual(1436, header.DataLength);
Assert.AreEqual(0, header.ChecksumData);
Assert.AreEqual(0, header.ChecksumHeader);
// No padding
}
public void TransferHeader()
{
Span <byte> span = new byte[128];
span.Fill(0xFF);
TransferHeader header = MemoryMarshal.Read <TransferHeader>(span);
Writer.InitTransferHeader(ref header);
// Header
Assert.AreEqual(Consts.FormatCode, header.FormatCode);
Assert.AreEqual(0, header.NumPackets);
Assert.AreEqual(Consts.ProtocolVersion, header.ProtocolVersion);
Assert.AreEqual(0, header.SequenceNumber);
Assert.AreEqual(0, header.DataLength);
Assert.AreEqual(0, header.ChecksumData);
Assert.AreEqual(0, header.ChecksumHeader);
// No padding
}
public bool TrasferIntHeaderAdd(TransferHeader header)
{
bool result = false;
string sql = "sp_TransferInHeader_Add";
List <SqlParameter> paramList = new List <SqlParameter>();
try
{
paramList = new List <SqlParameter>();
SqlParameter pvNewId = new SqlParameter("@TransferId", SqlDbType.NVarChar, 20);
pvNewId.Value = header.TransferId;
pvNewId.Direction = ParameterDirection.InputOutput;
paramList.Add(pvNewId);
paramList.Add(new SqlParameter("@TransferNo", header.TransferNo));
paramList.Add(new SqlParameter("@TransferType", header.TransferType));
paramList.Add(new SqlParameter("@TransferDate", header.TransferDate));
paramList.Add(new SqlParameter("@TransferTime", header.TransferTime));
paramList.Add(new SqlParameter("@JobOrderId", header.JobOrderId));
paramList.Add(new SqlParameter("@RefTransferId", header.RefTransferId));
paramList.Add(new SqlParameter("@ReceiveTo", header.ReceiveTo));
paramList.Add(new SqlParameter("@Reason", header.Reason));
paramList.Add(new SqlParameter("@CarType", header.CarType));
paramList.Add(new SqlParameter("@Company", header.Company));
paramList.Add(new SqlParameter("@CarNo", header.CarNo));
paramList.Add(new SqlParameter("@CarBrand", header.CarBrand));
paramList.Add(new SqlParameter("@SendToDepartment", header.SendToDepartment));
paramList.Add(new SqlParameter("@Remark", header.Remark));
paramList.Add(new SqlParameter("@EmpId", header.EmpId));
paramList.Add(new SqlParameter("@BillNo", header.BillNo));
paramList.Add(new SqlParameter("@TransferStatus", header.TransferStatus));
paramList.Add(new SqlParameter("@Note1", header.Note1));
paramList.Add(new SqlParameter("@CreatedBy", header.CreatedBy));
paramList.Add(new SqlParameter("@UpdatedBy", header.UpdatedBy));
webdb.ExcecuteNonQuery(sql, paramList);
header.TransferId = Convert.ToInt32(pvNewId.Value.ToString());
if (header.RefTransferIds != "" && header.RefTransferIds != "0")
{
sql = "sp_TransferHeaderReference_Add";
string[] refTransferId = header.RefTransferIds.Split(',');
foreach (string refId in refTransferId)
{
paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@TransferId", header.TransferId));
paramList.Add(new SqlParameter("@RefTransferId", refId));
webdb.ExcecuteNonQuery(sql, paramList);
}
}
// header.TransferId = Convert.ToInt32(webdb.ExcecuteNonScalar(sql, paramList));
}
catch (Exception ex)
{
throw new Exception("TrasferInApprove.Approve::" + ex.ToString());
}
finally
{ }
return(result);
}
public List <TransferHeader> GetTransferOutNotInList(string TransferType, DateTime?fromDate, DateTime?toDate)
{
/* var data = (from d in db.TransferHeader.Where(o => o.TransferType == TransferType)
* select new TransferHeader
* {
* TransferId = d.TransferId,
* TransferNo = d.TransferNo,
* TransferType = d.TransferType,
* TransferDate = d.TransferDate,
* StrTransferDate = "",
* TransferTime = d.TransferTime,
* JobOrderId = d.JobOrderId,
* ReceiveTo = d.ReceiveTo,
* Reason = d.Reason,
* CarType = d.CarType,
* Company = d.Company,
* CarNo = d.CarNo,
* CarBrand = d.CarBrand,
* SendToDepartment = d.SendToDepartment,
* Remark = d.Remark,
* EmpId = d.EmpId,
* BillNo = d.BillNo,
* TransferStatus = d.TransferStatus,
* StrTransferStatus = Converting.TransferStatus(d.TransferStatus.ToString()),
* Note1 = d.Note1,
* CreatedDate = d.CreatedDate,
* UpdatedDate = d.UpdatedDate
* });
* return data.ToList();*/
string sql = "sp_GetTransferOutNotIn";
List <SqlParameter> paramList = new List <SqlParameter>();
List <TransferHeader> list = new List <TransferHeader>();
TransferHeader dto = null;
SqlDataReader reader = null;
SqlCommand sqlCommand = null;
try
{
webdb.OpenConnection();
paramList.Add(new SqlParameter("@TransferType", TransferType));
paramList.Add(new SqlParameter("@FromDate", fromDate.HasValue ? string.Format("{0}{1}{2}", fromDate.Value.Year, fromDate.Value.Month.ToString("##00"), fromDate.Value.Day.ToString("##00")) : ""));
paramList.Add(new SqlParameter("@ToDate", toDate.HasValue ? string.Format("{0}{1}{2}", toDate.Value.Year, toDate.Value.Month.ToString("##00"), toDate.Value.Day.ToString("##00")) : ""));
//connect.Open();
sqlCommand = new SqlCommand();
sqlCommand.CommandText = sql;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = webdb.Connection;
sqlCommand.Parameters.AddRange(paramList.ToArray());
reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
dto = new TransferHeader();
dto.TransferId = Converting.ToInt(reader["TransferId"].ToString());
dto.TransferNo = reader["TransferNo"].ToString();
dto.TransferType = reader["TransferType"].ToString();
dto.TransferDate = Converting.StringToDate(reader["TransferDate"].ToString(), "dd/MM/yyyy");
dto.StrTransferDate = reader["TransferDate"].ToString();
dto.TransferTime = reader["TransferTime"].ToString();
dto.JobOrderId = Converting.ToInt(reader["JobOrderId"].ToString());
dto.ReceiveTo = reader["ReceiveTo"].ToString();
dto.Reason = reader["Reason"].ToString();
dto.CarType = Converting.ToInt(reader["CarType"].ToString());
dto.Company = reader["Company"].ToString();
dto.CarNo = reader["CarNo"].ToString();
dto.CarBrand = reader["CarBrand"].ToString();
dto.SendToDepartment = Converting.ToInt(reader["SendToDepartment"].ToString());
dto.Remark = reader["Remark"].ToString();
dto.EmpId = reader["EmpId"].ToString();
dto.BillNo = reader["BillNo"].ToString();
dto.TransferStatus = Converting.ToInt(reader["TransferStatus"].ToString());
dto.StrTransferStatus = Converting.TransferStatus(reader["TransferStatus"].ToString());
dto.Note1 = reader["Note1"].ToString();
dto.CreatedDate = Converting.StringToDate(reader["CreatedDate"].ToString(), "dd/MM/yyyy");
dto.UpdatedDate = Converting.StringToDate(reader["UpdatedDate"].ToString(), "dd/MM/yyyy");
list.Add(dto);
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
if (webdb.Connection.State == ConnectionState.Open)
{
webdb.CloseConnection();
}
}
return(list);
}
public ActionResult SetDetail(TransferHeader obj)
{
System.Globalization.CultureInfo _cultureTHInfo = new System.Globalization.CultureInfo("en-US");
string TransferId = this.Request.Form["TransferId"];
string refTransferId = Request.Form["RefTransferIds"] != null ? Request.Form["RefTransferIds"].ToString() : "";
/* string StartHH = this.Request.Form["StartHH"];
* string StartMM = this.Request.Form["StartMM"];
* string EndHH = this.Request.Form["EndHH"];
* string EndMM = this.Request.Form["EndMM"];
* string SaleName = this.Request.Form["SaleName"];
* string SaleMobile = this.Request.Form["SaleMobile"];
* string hddProject = this.Request.Form["hddProject"];
* string hddEquipmentType = this.Request.Form["hddEquipmentType"];
* string hddLandType = this.Request.Form["hddLandType"];
* string hddUndergroundType = this.Request.Form["hddUndergroundType"];
* string hddObstructionType = this.Request.Form["hddObstructionType"];
* string hddAttachmentType = this.Request.Form["hddAttachmentType"];
*/
if (TransferId == "" || TransferId == "0")
{
obj.TransferNo = getId("I");
obj.CreatedDate = DateTime.Now;
obj.RefTransferIds = refTransferId;
}
else
{
obj.TransferId = Convert.ToInt32(TransferId);
obj.UpdatedDate = DateTime.Now;
}
obj.TransferType = "I";
if (Request.Form["TransferDate"].ToString() != "")
{
var dd = Request.Form["TransferDate"];
obj.TransferDate = Convert.ToDateTime(dd, _cultureTHInfo); //dd.ParseDate(DateFormat.ddMMyyyy, culInfo: _cultureTHInfo);
}
// obj.EmpId = "1";
/*# hddProject
# hddEquipmentType
# hddLandType
# hddUndergroundType
# hddObstructionType
# hddAttachmentType
*/
try
{
uow.Modules.Transfer.SetIn(obj);
// uow.SaveChanges();
// uow.Modules.Transfer.Set(obj);
// uow.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.GetMessage(true);
return(ViewDetail(obj, msg, AlertMsgType.Danger));
}
return(RedirectToAction("Detail", MVCController, new { id = obj.TransferId, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success }));
// return RedirectToAction("Detail", MVCController, new { id = 1, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success });
}
private void detach_TransferHeaders1(TransferHeader entity)
{
this.SendPropertyChanging("TransferHeaders1");
entity.Warehouse1 = null;
}
private void detach_TransferHeaders(TransferHeader entity)
{
this.SendPropertyChanging("TransferHeaders");
entity.Dealer = null;
}
private void attach_TransferHeaders(TransferHeader entity)
{
this.SendPropertyChanging("TransferHeaders");
entity.Warehouse = this;
}
public bool Add(TransferHeader ob)
{
bool result = false;
string sql = "sp_TransferHeader_Insert";
List <SqlParameter> paramList = new List <SqlParameter>();
try
{
/* @TransferId int
*
* , @TransferNo nvarchar(15)
* ,@TransferType nvarchar(3)
* ,@TransferDate nvarchar(50)
* ,@TransferTime nvarchar(5)
* ,@JobOrderId int
* , @RefTransferId int
*
* , @ReceiveTo nvarchar(50)
* ,@Reason nvarchar(100)
* ,@CarType int
* , @Company nvarchar(100)
* ,@CarNo nchar(10)
* ,@CarBrand nchar(10)
* ,@SendToDepartment int
* , @Remark nvarchar(100)
* ,@EmpId nvarchar(10)
* ,@BillNo nvarchar(50)
* ,@TransferStatus int
* , @Note1 varchar(50)
* ,@CreatedDate datetime
* , @CreatedBy int
*
* , @UpdatedDate datetime
* ,@UpdatedBy int
* , @ApprovedBy int
*/
paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@TransferId", ob.TransferId));
paramList.Add(new SqlParameter("@TransferType", ob.TransferType));
paramList.Add(new SqlParameter("@TransferDate", ob.TransferDate));
paramList.Add(new SqlParameter("@TransferTime", ob.TransferTime));
paramList.Add(new SqlParameter("@JobOrderId", ob.JobOrderId));
paramList.Add(new SqlParameter("@RefTransferId", ob.RefTransferId));
paramList.Add(new SqlParameter("@ReceiveTo", ob.ReceiveTo));
paramList.Add(new SqlParameter("@Reason", ob.Reason));
paramList.Add(new SqlParameter("@CarType", ob.CarType));
paramList.Add(new SqlParameter("@Company", ob.Company));
paramList.Add(new SqlParameter("@CarNo", ob.CarNo));
paramList.Add(new SqlParameter("@CarBrand", ob.CarBrand));
paramList.Add(new SqlParameter("@SendToDepartment", ob.SendToDepartment));
paramList.Add(new SqlParameter("@Remark", ob.Remark));
paramList.Add(new SqlParameter("@EmpId", ob.EmpId));
paramList.Add(new SqlParameter("@BillNo", ob.BillNo));
paramList.Add(new SqlParameter("@TransferStatus", ob.TransferStatus));
paramList.Add(new SqlParameter("@Note1", ob.Note1));
// paramList.Add(new SqlParameter("@CreatedDate", ob.CreatedDate));
paramList.Add(new SqlParameter("@CreatedBy", ob.CreatedBy));
// paramList.Add(new SqlParameter("@UpdatedDate", ob.CreatedBy));
paramList.Add(new SqlParameter("@UpdatedBy", ob.CreatedBy));
paramList.Add(new SqlParameter("@ApprovedBy", ob.CreatedBy));
result = webdb.ExcecuteNonQuery(sql, paramList);
result = webdb.ExcecuteNonQuery(sql, paramList);
}
catch (Exception ex)
{
throw new Exception("TransferDetail.Insert::" + ex.ToString());
}
finally
{ }
return(result);
}
public bool TrasferOutHeaderAdd(TransferHeader header)
{
bool result = false;
string sql = "sp_TransferOutHeader_Add";
List <SqlParameter> paramList = new List <SqlParameter>();
try
{
/* [TransferId]
* ,[TransferNo]
* ,[TransferType]
* ,[TransferDate]
* ,[TransferTime]
* ,[JobOrderId]
* ,[RefTransferId]
* ,[ReceiveTo]
* ,[Reason]
* ,[CarType]
* ,[Company]
* ,[CarNo]
* ,[CarBrand]
* ,[SendToDepartment]
* ,[Remark]
* ,[EmpId]
* ,[BillNo]
* ,[TransferStatus]
* ,[Note1]
* ,[CreatedDate]
* ,[CreatedBy]
* ,[UpdatedDate]
* ,[UpdatedBy]
* ,[ApprovedBy]*/
paramList = new List <SqlParameter>();
SqlParameter pvNewId = new SqlParameter("@TransferId", SqlDbType.NVarChar, 20);
pvNewId.Value = header.TransferId;
pvNewId.Direction = ParameterDirection.InputOutput;
paramList.Add(pvNewId);
paramList.Add(new SqlParameter("@TransferNo", header.TransferNo));
paramList.Add(new SqlParameter("@TransferType", header.TransferType));
paramList.Add(new SqlParameter("@TransferDate", header.TransferDate));
paramList.Add(new SqlParameter("@TransferTime", header.TransferTime));
paramList.Add(new SqlParameter("@JobOrderId", header.JobOrderId));
paramList.Add(new SqlParameter("@RefTransferId", header.RefTransferId));
paramList.Add(new SqlParameter("@ReceiveTo", header.ReceiveTo));
paramList.Add(new SqlParameter("@Reason", header.Reason));
paramList.Add(new SqlParameter("@CarType", header.CarType));
paramList.Add(new SqlParameter("@Company", header.Company));
paramList.Add(new SqlParameter("@CarNo", header.CarNo));
paramList.Add(new SqlParameter("@CarBrand", header.CarBrand));
paramList.Add(new SqlParameter("@SendToDepartment", header.SendToDepartment));
paramList.Add(new SqlParameter("@Remark", header.Remark));
paramList.Add(new SqlParameter("@EmpId", header.EmpId));
paramList.Add(new SqlParameter("@BillNo", header.BillNo));
paramList.Add(new SqlParameter("@TransferStatus", header.TransferStatus));
paramList.Add(new SqlParameter("@Note1", header.Note1));
paramList.Add(new SqlParameter("@CreatedBy", header.CreatedBy));
paramList.Add(new SqlParameter("@UpdatedBy", header.UpdatedBy));
webdb.ExcecuteWitTranNonQuery(sql, paramList);
// header.TransferId = Convert.ToInt32(webdb.ExcecuteNonScalar(sql, paramList));
header.TransferId = Convert.ToInt32(pvNewId.Value.ToString());
}
catch (Exception ex)
{
throw new Exception("TrasferInApprove.Approve::" + ex.ToString());
}
finally
{ }
return(result);
}
public ActionResult Detail(int?id, string msg, AlertMsgType?msgType)
{
TransferHeader ob = uow.Modules.Transfer.Get(id ?? 0);
return(ViewDetail(ob, msg, msgType));
}
public TransferHeader Get(int id)
{
TransferHeader transferHeader = (from q in db.TransferHeader.Where(t => t.TransferId == id)
select new TransferHeader
{
TransferId = q.TransferId,
TransferNo = q.TransferNo,
TransferType = q.TransferType,
TransferDate = q.TransferDate,
TransferTime = q.TransferTime,
JobOrderId = q.JobOrderId,
RefTransferId = q.RefTransferId,
ReceiveTo = q.ReceiveTo,
Reason = q.Reason,
CarType = q.CarType,
Company = q.Company,
CarNo = q.CarNo,
CarBrand = q.CarBrand,
SendToDepartment = q.SendToDepartment,
Remark = q.Remark,
EmpId = q.EmpId,
BillNo = q.BillNo,
TransferStatus = q.TransferStatus,
Note1 = q.Note1,
CreatedDate = q.CreatedDate,
UpdatedDate = q.UpdatedDate
}).FirstOrDefault() ?? new TransferHeader()
{
};
var detail = (from q in db.TransferDetail.Where(t => t.TransferId == id) select q).ToList();
if (detail != null && detail.Count > 0)
{
transferHeader.TransferDetail = (from q in db.TransferDetail.Include(x => x.Product)
where q.TransferId == id
select new TransferDetail
{
TransferId = q.TransferId,
RefTransferId = q.RefTransferId,
RefTransferNo = (q.RefTransferId == 0?null:(from tDetail in db.TransferHeader.Where(t => t.TransferId == q.RefTransferId) select tDetail.TransferNo).FirstOrDefault().ToString()),
Seq = q.Seq,
ProductId = q.ProductId,
CurrentQty = q.CurrentQty,
RequestQty = q.RequestQty,
RequestUnit = q.RequestUnit,
RequestUnitFactor = q.RequestUnitFactor,
LastModified = q.LastModified,
Product = db.TblProduct.Where(p => p.ProductId == q.ProductId).FirstOrDefault()
}).ToList();
}
transferHeader.JobOrder = (from q in db.TblJobOrder.Where(o => o.JobOrderId == transferHeader.JobOrderId)
.Include(x => x.SaleOrder)
.Include(x => x.JobOrderDetail) select q).FirstOrDefault();
/*if (transferHeader.RefTransferId != null && transferHeader.RefTransferId>0)
* {
* transferHeader.RefTransfer = (from q in db.TransferHeader.Where(t => t.TransferId == transferHeader.RefTransferId) select new TransferHeader {
* TransferId =q.TransferId,
* TransferNo = q.TransferNo ,
* TransferType = q.TransferType ,
* TransferDate = q.TransferDate,
* TransferTime = q.TransferTime ,
* JobOrderId = q.JobOrderId,
* RefTransferId = q.RefTransferId,
* ReceiveTo = q.ReceiveTo ,
* Reason = q.Reason ,
* CarType = q.CarType,
* Company = q.Company ,
* CarNo = q.CarNo ,
* CarBrand = q.CarBrand ,
* SendToDepartment = q.SendToDepartment,
* Remark = q.Remark ,
* EmpId = q.EmpId ,
* BillNo = q.BillNo ,
* TransferStatus = q.TransferStatus,
* Note1 = q.Note1 ,
* CreateDate = q.CreateDate,
* UpdateDate = q.UpdateDate
* }).FirstOrDefault()??new TransferHeader
* {
*
* };
* }*/
return(transferHeader);
}
