public ActionResult CreateEdit(PRODUCT_TYPE model)
{
if (model.ID == 0)
{
var result = LoaiSanPham.Create(model);
return
(Json(
new RedirectCommand()
{
Code = result.Code, Message = result.Message, Url = Url.Action("Index", new { id = model.ID })
},
JsonRequestBehavior.AllowGet));
}
else
{
var result = LoaiSanPham.Edit(model);
return
(Json(
new RedirectCommand()
{
Code = result.Code, Message = result.Message, Url = Url.Action("Index", new { id = model.ID })
},
JsonRequestBehavior.AllowGet));
}
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
PRODUCT_TYPE theEntity = (PRODUCT_TYPE)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_CATEGORY_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_CATEGORY_ID", theEntity.PRODUCT_CATEGORY_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCTTYPE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_TYPE", theEntity.PRODUCTTYPE));
}
if (!string.IsNullOrEmpty(theEntity.REMARKS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REMARKS", theEntity.REMARKS));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_TYPE_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_TYPE_CODE", theEntity.PRODUCT_TYPE_CODE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
public ProductTypeEdit(PRODUCT_TYPE pt, Product_typeVM ptvm)
{
InitializeComponent();
Product_typeEditVM vm = new Product_typeEditVM(pt, ptvm);
this.DataContext = vm;
}
public async Task <ICollection <ProductDto> > GetAllAsync(PRODUCT_TYPE productType)
{
return(await this.context.Products
.Where(p => p.ProductType == productType)
.ProjectTo <ProductDto>(this.mapper.ConfigurationProvider)
.ToListAsync());
}
public void Product_type_update()
{
PRODUCT_TYPE pt = new PRODUCT_TYPE();
pt.NAME = "suc nam";
pt.PRODUCT_TYPE_CD = "sn";
ptd.Update(pt);
}
public void Product_type_insert()
{
PRODUCT_TYPE pt = new PRODUCT_TYPE();
pt.NAME = "suc nu";
pt.PRODUCT_TYPE_CD = "sn";
ptd.Insert(pt);
}
private void button1_Click(object sender, EventArgs e)
{
Product_TypeDao ptd = new Product_TypeDao();
PRODUCT_TYPE pt = new PRODUCT_TYPE();
pt.NAME = txt.Text;
ptd.Insert(pt);
}
private void ShowEditForm(PRODUCT_TYPE p)
{
if (p != null)
{
ProductTypeEdit pt = new ProductTypeEdit(p, this);
pt.Show();
pt.txtProductTypecd.IsReadOnly = true;
}
}
public static ProductDto GetEmptyProductDto(PRODUCT_TYPE productType)
{
return(new ProductDto
{
ProductType = productType,
QuantityInStock = 1.00M,
UnitPrice = 0.00M,
});
}
public static CommandResult Create(PRODUCT_TYPE c)
{
using (var context = new GST_MockProjectEntities())
{
context.PRODUCT_TYPE.Add(c);
context.SaveChanges();
//TODO
//context.Log(c, LogType.BankBranch_Create, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
public static CommandResult Edit(PRODUCT_TYPE c)
{
using (var context = new GST_MockProjectEntities())
{
var Loaisanpham = context.PRODUCT_TYPE.First(x => x.ID == c.ID);
Loaisanpham.ProductTypeName = c.ProductTypeName;
Loaisanpham.Status = c.Status;
context.SaveChanges();
//TODO
// context.Log(c, LogType.Customer_Edit, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr)
{
PRODUCT_TYPE theEntity = new PRODUCT_TYPE();
theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty;
theEntity.PRODUCT_CATEGORY_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty;
theEntity.PRODUCTTYPE = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty;
theEntity.REMARKS = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty;
theEntity.PRODUCT_TYPE_CODE = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty;
return(theEntity);
}
private void OKevent(Window p)
{
PRODUCT_TYPE pt = new PRODUCT_TYPE();
pt.PRODUCT_TYPE_CD = Product_type_cd;
pt.NAME = Name;
if (cv == "insert")
{
Product_TypeDao.Instance().Insert(pt);
}
else
{
Product_TypeDao.Instance().Update(pt);
}
vm.Product_typeLists = null;
vm.Product_typeLists = new System.Collections.ObjectModel.ObservableCollection <PRODUCT_TYPE>(Product_TypeDao.Instance().getAll());
p.Close();
}
public Product_typeEditVM(PRODUCT_TYPE pt, Product_typeVM vm)
{
if (pt == null)
{
this.Product_type_cd = "";
this.Name = "";
this.cv = "insert";
}
else
{
this.Product_type_cd = pt.PRODUCT_TYPE_CD;
this.Name = pt.NAME;
this.cv = "update";
}
this.vm = vm;
OKCommand = new RelayCommand <Window>((p) => { return(p != null ? true : false); }, (p) => { OKevent(p); });
CancelCommand = new RelayCommand <Window>((p) => true, (p) => { p.Close(); });
}
private List <PRODUCT_TYPE> MapDEBT(DataTable dt)
{
List <PRODUCT_TYPE> rs = new List <PRODUCT_TYPE>();
for (int i = 0; i < dt.Rows.Count; i++)
{
PRODUCT_TYPE obj = new PRODUCT_TYPE();
if (dt.Columns.Contains("Product_Type_ID"))
{
obj.Product_Type_ID = int.Parse(dt.Rows[i]["Product_Type_ID"].ToString());
}
if (dt.Columns.Contains("Product_Name"))
{
obj.Product_Name = dt.Rows[i]["Product_Name"].ToString();
}
rs.Add(obj);
}
return(rs);
}
public void SpawnObject(PRODUCT_TYPE objectType)
{
ObjectType = objectType;
switch (ObjectType)
{
case PRODUCT_TYPE.STRAP:
{
_factory = new StrapsFactory();
//Debug.Log(lastStrap.name);
} break;
case PRODUCT_TYPE.LIGHT_BUSRST:
{
_factory = new LightBurstFactory();
} break;
}
GameObject prefab = _factory.CreateProduct();
_objectStartPosition = gameObject.transform.position;
_objectStartPosition.x += prefab.transform.localScale.x / 2;
_lastObject = GameObject.Instantiate(prefab, _objectStartPosition, Quaternion.Euler(0, 0, 0)) as GameObject;
}
public ProductTypeDataModel(PRODUCT_TYPE productType)
{
Id = productType.ID;
Name = productType.NAME;
Description = productType.DESCRIPTION;
}
private void RemoveProduct_type(PRODUCT_TYPE pt)
{
Product_TypeDao.Instance().Delete(pt.PRODUCT_TYPE_CD);
Product_typeLists = null;
Product_typeLists = new ObservableCollection <PRODUCT_TYPE>(Product_TypeDao.Instance().getAll());
}
/// <summary>
/// Attempts to classify the indicated infoset using the product type taxonomy.
/// </summary>
/// <param name="infoset">The product infoset as a DOM tree.</param>
/// <returns>The <see cref="Category"/> instance representing the product type
/// corresponding to the product infoset.</returns>
public static Category ProductTypeForInfoset(XmlElement infoset)
{
return((infoset != null) ? PRODUCT_TYPE.Classify(infoset) : null);
}
public static string guess_os(uint MajorVersion, uint MinorVersion, PRODUCT_TYPE ProductType)
{
string OperatingSystem = "";
if (MajorVersion == 10 && MinorVersion == 0 &&
ProductType == PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows 10";
}
else if (MajorVersion == 10 && MinorVersion == 0 &&
ProductType != PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows Server 2016 Technical Preview";
}
else if (MajorVersion == 6 && MinorVersion == 3 &&
ProductType == PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows 8.1";
}
else if (MajorVersion == 6 && MinorVersion == 3 &&
ProductType != PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows Server 2012 R2";
}
else if (MajorVersion == 6 && MinorVersion == 2 &&
ProductType == PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows 8";
}
else if (MajorVersion == 6 && MinorVersion == 2 &&
ProductType != PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows Server 2012";
}
else if (MajorVersion == 6 && MinorVersion == 1 &&
ProductType == PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows 7";
}
else if (MajorVersion == 6 && MinorVersion == 1 &&
ProductType != PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows Server 2008 R2";
}
else if (MajorVersion == 6 && MinorVersion == 0 &&
ProductType == PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows Vista";
}
else if (MajorVersion == 6 && MinorVersion == 0 &&
ProductType != PRODUCT_TYPE.VER_NT_WORKSTATION)
{
OperatingSystem = "Windows Server 2008";
}
else if (MajorVersion == 5 && MinorVersion == 1)
{
// Can't accurately report on Windows Server 2003/R2
// elif (MajorVersion == 5 and MinorVersion == 2 and ProductType == self.ProductType.VER_NT_WORKSTATION)
// self.OperatingSystem = "Windows Vista"
//elif (MajorVersion == 5 and MinorVersion == 2 and ProductType != self.ProductType.VER_NT_WORKSTATION)
// self.OperatingSystem = "Windows Server 2008"
OperatingSystem = "Windows XP";
}
else if (MajorVersion == 5 && MinorVersion == 0)
{
OperatingSystem = "Windows 2000";
}
return(OperatingSystem);
}
private void showEditDataWnd(PRODUCT_TYPE nProductType, string strNumber)
{
List<string> listDBField = new List<string>();
List<string> listDBEntry = new List<string>();
listDBEntry.Add(String.Format("{0} in ({1})", LaBelleCmnDef.strDBNumber, strNumber));
string strTableName = LaBelleCmnDef.strDBTableName[(uint)nProductType];
List<Dictionary<string, string>> listData = dbLaBelleExcel.Select(strTableName, listDBField, listDBEntry);
if (listData.Count != 1)
MessageBox.Show(String.Format("搜尋到{0}筆資料", listData.Count), "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error);
LaBelleForm FormLaBelle = new LaBelleForm();
FormLaBelle.MdiParent = this;
FormLaBelle.ProductType = nProductType;
FormLaBelle.LaBelleFormStatus = LABELLE_FORM_STATUS.LABELLE_FORM_STATUS_EDIT;
FormLaBelle.DBNumber = Convert.ToUInt32(strNumber);
FormLaBelle.Visible = false;
FormLaBelle.Show();
FormLaBelle.UpdateCtrlFromDB(listData[0]);
FormLaBelle.Visible = true;
}
private void BtnSelProductOK_Click(object sender, EventArgs e)
{
nProductType = (PRODUCT_TYPE)ComboSelProduct.SelectedIndex;
DialogResult = DialogResult.OK;
}
