文件操作 - Products.js
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\crm.kimbly.in\wwwroot\js\Products.js
编辑文件内容
function SearchProducts() { var ProductCode = document.getElementById('Products_Search_txtProduct_Code').value; var Brand = document.getElementById('Products_Search_txtMake').value; var Category = document.getElementById('Products_Search_txtCategory').value; var Description = document.getElementById('Products_Search_txtDescription').value; var collection = "Products"; $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "WebMethods/Products.aspx/SearchProductsByParameters", data: "{'ProductCode': '" + ProductCode + "','Brand': '" + Brand + "','Category': '" + Category + "','Description': '" + Description + "'}", dataType: "json", success: function (data) { if (data.d != null) { console.log(data.d); $("#grd" + collection).empty(); var str = "<thead><tr><td>ID</td><td>ProductCode</td><td>Description</td><td>Brand</td><td>Category</td><td>Price</td></tr></thead><tbody>"; for (i = 0; i < data.d.length; i++) { var hdr = data.d[i].RowData; str += hdr; } $("#grd" + collection).append(str); $("#grd" + collection).append("</tbody>"); $("#grd" + collection).show(); $("#dvGrdReport" + collection).show(); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); } function AddNewProducts() { showHome(); $('#dvFrm').show(); var ctrl = $(document.createElement('div')).attr("id", 'dvRight'); var manage = '<a href="#" class="btn btn-default" onclick="Master_Product_Make()" data-toggle="modal" data-target="#ManageMasterModal"><i class="icon-th-list"></i></a>'; var manage2 = '<a href="#" class="btn btn-default" onclick="Master_Product_Category()" data-toggle="modal" data-target="#ManageMasterModal"><i class="icon-th-list"></i></a>'; var content = '<div class="spacer"></div><div class="form-horizontal"><div class="control-group"><div style="-webkit-border-radius: 6px;-moz-border-radius: 6px;border-radius: 6px;border:1px solid #E5E5E5;"><div class="modal-header" style="padding:10px"><a class="close" data-dismiss="modal" onclick="HideAddForm()">x</a><b style="font-size: 20px;">New Product</b></div><div class="modal-body" style="padding:5px"><form id="frmMain" name="frmMain" method="post" class="form-horizontal" enctype="multipart/form-data"><div class="form-group"><label class="col-sm-2 control-label">Product Code</label><div class="col-sm-4"><input class="form-control" id="txtProductsProductCode" data-fieldtype="SingleLine" type="text"></div><label class="col-sm-2 control-label">Description</label><div class="col-sm-4"><input class="form-control" id="txtProductsDescription" data-fieldtype="SingleLine" type="text"></div></div><div class="form-group"><label class="col-sm-2 control-label">Price</label><div class="col-sm-4"><input class="form-control" id="txtProductsPrice" data-fieldtype="SingleLine" type="text" value="1"></div><label class="col-sm-2 control-label">Category</label><div class="col-sm-4"><select class="form-control" id="SelProductsCategoryID" style="width: 75%;float: left;"></select>' + manage2 + '</div></div><div class="form-group"><label class="col-sm-2 control-label">Make</label><div class="col-sm-4"><select class="form-control" id="SelProductsMake" style="width: 75%;float: left;"></select>' + manage + '</div><label class="col-sm-2 control-label">Unit</label><div class="col-sm-4"><input class="form-control" id="txtProductsUnit" data-fieldtype="SingleLine" type="text"></div></div><div class="form-group"><label class="col-sm-2 control-label">Col1</label><div class="col-sm-4"><input class="form-control" id="txtProductsCol1" data-fieldtype="SingleLine" type="text"></div><label class="col-sm-2 control-label">Col2</label><div class="col-sm-4"><input class="form-control" id="txtProductsCol2" data-fieldtype="SingleLine" type="text"></div></div></form></div><div class="modal-footer" style="text-align:right; padding:10px"><button type="button" class="btn btn-success" onclick="SaveProducts()">Save</button></div></div></div></div>'; $("#dvFrm").html(""); $("#dvFrm").empty(); ctrl.html(content); ctrl.appendTo("#dvFrm"); getProductMake(1); getProductCategory(1); } function EditProduct(ID) { var formname = 'Products'; $('#infoContainer').children().hide(); $('#secondScreen').show(); $('#' + formname).show(); $('#DvFrmEdit' + formname).show(); $('#Dv' + formname + 'Frm').hide(); var prefix = formname + '_edit_txt'; var targetdiv = 'DvFrmEdit' + formname; var ctrl = $(document.createElement('div')).attr('id', 'dvRight'); var hdr = '<div class="spacer"></div><div class="form-horizontal"><div class="control-group"><div style="-webkit-border-radius: 6px;-moz-border-radius: 6px;border-radius: 6px;border:1px solid #E5E5E5;"><div class="modal-header"><a class="close" data-dismiss="modal" onclick="closeEditForm(4)">x</a><b style="font-size: 20px;"><label id="EditProductsID"></label></b><sub style="margin-left: 430px"> <label id="TitleAuthProducts"></label></sub></div><div class="modal-body">'; var frm = '<form id="frmEditProducts" name="frmEditProducts"><div class="form-group"><label class="col-sm-2 control-label">Product Code</label><div class="col-sm-4"><input class="form-control" id="txtEditProductsProductCode" data-fieldtype="SingleLine" type="text"></div><label class="col-sm-2 control-label">Description</label><div class="col-sm-4"><input class="form-control" id="txtEditProductsDescription" data-fieldtype="SingleLine" type="text"></div></div><div class="form-group"><label class="col-sm-2 control-label">Price</label><div class="col-sm-4"><input class="form-control" id="txtEditProductsPrice" data-fieldtype="SingleLine" type="text"></div><label class="col-sm-2 control-label">Category</label><div class="col-sm-4"><select class="form-control" id="SelEditProductsCategoryID" ></select></div></div><div class="form-group"><label class="col-sm-2 control-label">Make</label><div class="col-sm-4"><select class="form-control" id="SelEditProductsMake" ></select></div><label class="col-sm-2 control-label">Unit</label><div class="col-sm-4"><input class="form-control" id="txtEditProductsUnit" data-fieldtype="SingleLine" type="text"></div></div><div class="form-group"><label class="col-sm-2 control-label">Col1</label><div class="col-sm-4"><input class="form-control" id="txtEditProductsCol1" data-fieldtype="SingleLine" type="text"></div><label class="col-sm-2 control-label">Col2</label><div class="col-sm-4"><input class="form-control" id="txtEditProductsCol2" data-fieldtype="SingleLine" type="text"></div></div></div></form>'; var panels = '<div class="panel panel-default"><div id="DVProductsComments" class="panel-body" style="display:none;"></div><div class="panel panel-default" style="margin-top: 5px;"><div id="DVProductsDocs" class="panel-body" style="display:none;"></div></div></div>'; var ftr = '<div class="modal-footer"><div class="form-group"><div style="float:left;">'; var str = "'Products'"; var params = "'Products'," + ID; ftr += '<button id="BtnEmailProducts" class="btn btn-default" onclick="EMailItem(' + str + ',' + ID + ')"><i class="icon-envelope"></i>Mail</button>'; ftr += '<button id="BtnHistoryProducts" class="btn btn-default" data-toggle="modal" data-target="#DVHistory" onclick="ViewHistory(' + str + ',' + ID + ')"><i class="icon-film"></i>History</button>'; ftr += '<button id="BtnDocProducts" class="btn btn-default" data-toggle="modal" data-target="#DocumentUploadModal" onclick="AddDoc(' + str + ',' + ID + ')"><i class="icon-upload"></i>Doc</button>'; ftr += '<button id="BtnCommentProducts" class="btn btn-default" data-toggle="modal" data-target="#myModal" onclick="StartComment(' + params + ')"><i class="icon-pencil"></i>Comment</button></div><div style="float:right;"><button id="btnDeleteProducts" type="button" class="btn btn-danger" onclick="DeleteFormValues(' + params + ')">Delete</button><button id="btnUpdateProducts" type="button" class="btn btn-success" onclick="Update_Products(' + ID + ')">Save</button></div></div></div></div></div></div>'; content = hdr + frm + panels + ftr; $('#' + targetdiv).html(''); $('#' + targetdiv).empty(); ctrl.html(content); ctrl.appendTo('#' + targetdiv); $('#' + targetdiv).show(); getProductMake(2); getProductCategory(2); setTimeout(function () { GetProductsByID(ID); GetAssociatedComments(formname, ID); getDocs(formname, ID); }, 500); CheckProductRestrictions(); } function CheckProductRestrictions() { $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "WebMethods/Contacts.aspx/GetRestrictionsByFormNameEmpID", data: "{'FormName': '" + 'Products' + "'}", dataType: "json", success: function (data) { if (data.d != null) { for (i = 0; i < data.d.length; i++) { var nm = data.d[i].RowData; console.log('CheckProductRestrictions nm-' + nm); if (nm == "Update") { $("#btnUpdateProducts").hide(); } else if (nm == "Delete") { $("#btnDeleteProducts").hide(); } else if (nm == "Mail") { $("#BtnEmailProducts").hide(); } else if (nm == "Comment") { $("#BtnCommentProducts").hide(); } else if (nm == "Add Doc") { $("#BtnDocProducts").hide(); } else if (nm == "View History") { $("#BtnHistoryProducts").hide(); } else if (nm == "View Price") { $("#txtEditProductsPrice").hide(); $("#btnUpdateProducts").hide(); } } } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); } function GetProductsByID(ID) { $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "WebMethods/Products.aspx/GetProductsByID", data: "{'ID':'" + ID + "'}", dataType: "json", success: function (data) { if (data.d != null) { var obj = JSON.parse(data.d); document.getElementById("EditProductsID").innerHTML = obj[0].ID; $("#txtEditProductsProductCode").val(obj[0].ProductCode); $("#txtEditProductsDescription").val(obj[0].Description); $("#txtEditProductsPrice").val(obj[0].Price); $("#txtEditProductsCategoryID").val(obj[0].CategoryID); $("#txtEditProductsMake").val(obj[0].Make); $("#txtEditProductsUnit").val(obj[0].Unit); $("#txtEditProductsCol1").val(obj[0].Col1); $("#txtEditProductsCol2").val(obj[0].Col2); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); } function Update_Products(ID) { var ProductCode = document.getElementById('txtEditProductsProductCode').value; var Description = document.getElementById('txtEditProductsDescription').value; var Price = document.getElementById('txtEditProductsPrice').value; var CategoryID = document.getElementById('SelEditProductsCategoryID').value; var Make = document.getElementById('SelEditProductsMake').value; var Unit = document.getElementById('txtEditProductsUnit').value; var Col1 = document.getElementById('txtEditProductsCol1').value; var Col2 = document.getElementById('txtEditProductsCol2').value; $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "WebMethods/Products.aspx/Update_Products", data: "{'ID':'" + ID + "','ProductCode':'" + ProductCode + "','Description':'" + Description + "','Price':'" + Price + "','CategoryID':'" + CategoryID + "','Make':'" + Make + "','Unit':'" + Unit + "','Col1':'" + Col1 + "','Col2':'" + Col2 + "','LoggedInEmpID':'" + LoggedInEmpID + "'}", dataType: "json", success: function (data) { if (data.d != null) { console.log('Update_Products done'); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); } function getProductMake(f) { $.ajax({ type: "POST", url: "WebMethods/Support.aspx/GetSupportBrands", data: "", contentType: "application/json; charset=utf-8", dataType: "json", success: function (data) { if (data.d != null) { var select; if (f == '1') { select = document.getElementById('SelProductsMake'); } else { select = document.getElementById('SelEditProductsMake'); } select.options.length = 0; var obj = JSON.parse(data.d); for (i = 0; i < obj.length; i++) { select.options[select.options.length] = new Option(obj[i].Name, obj[i].ID); } } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); } function getProductCategory(f) { $.ajax({ type: "POST", url: "WebMethods/Products.aspx/GetProductCategories", data: "", contentType: "application/json; charset=utf-8", dataType: "json", success: function (data) { if (data.d != null) { var select; if (f == '1') { select = document.getElementById('SelProductsCategoryID'); } else { select = document.getElementById('SelEditProductsCategoryID'); } select.options.length = 0; var obj = JSON.parse(data.d); for (i = 0; i < obj.length; i++) { select.options[select.options.length] = new Option(obj[i].Name, obj[i].ID); } } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); } function SaveProducts() { var Name = document.getElementById('txtProductsProductCode').value; if (Name == '') { $('#txtProductsProductCode').css("border-color", "red"); return; } else { $('#txtProductsProductCode').css("border-color", "#ccc"); } var Price = document.getElementById('txtProductsPrice').value; if (Price == '') { $('#txtProductsPrice').css("border-color", "red"); return; } else { $('#txtProductsPrice').css("border-color", "#ccc"); } var ProductCode = document.getElementById('txtProductsProductCode').value; var Description = document.getElementById('txtProductsDescription').value; var CategoryID = document.getElementById('SelProductsCategoryID').value; var Make = document.getElementById('SelProductsMake').value; var Unit = document.getElementById('txtProductsUnit').value; var Col1 = document.getElementById('txtProductsCol1').value; var Col2 = document.getElementById('txtProductsCol2').value; $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "WebMethods/Products.aspx/INSERT_Products", data: "{'ProductCode':'" + ProductCode + "','Description':'" + Description + "','Price':'" + Price + "','CategoryID':'" + CategoryID + "','Make':'" + Make + "','Unit':'" + Unit + "','Col1':'" + Col1 + "','Col2':'" + Col2 + "','LoggedInEmpID':'" + LoggedInEmpID + "'}", dataType: "json", success: function (data) { if (data.d != null) { ResetAddProduct(); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); } function ResetAddProduct() { document.getElementById('txtProductsProductCode').value = ""; document.getElementById('txtProductsDescription').value = ""; document.getElementById('txtProductsPrice').value = ""; document.getElementById('SelProductsCategoryID').value = ""; document.getElementById('SelProductsMake').value = ""; document.getElementById('txtProductsUnit').value = ""; document.getElementById('txtProductsCol1').value = ""; document.getElementById('txtProductsCol2').value=""; } function LookupProducts(ctrl, ctrlName) { console.log(ctrlName); $("#" + ctrlName).autocomplete({ source: function (request, response) { $.ajax({ type: "POST", url: "WebMethods/Products.aspx/LookupProducts", data: "{'prefix': '" + ctrl.value + "'}", contentType: "application/json; charset=utf-8", dataType: "json", success: function (data) { if (data.d != null) { var SearchResult = new Array(); for (var i = 0; i < data.d.length; i++) { SearchResult[i] = data.d[i].RowData; } response(SearchResult); } }, error: function (XMLHttpRequest, textStatus, errorThrown) { console.log('error'); } }); }, open: function (event, ui) { disable = true }, close: function (event, ui) { disable = false; $(this).focus(); } }); } function Master_Product_Make() { $("#MasterFrame").attr("src", "WebForms/ManageBrands.aspx"); document.getElementById('MasterFormName').value = "Products"; document.getElementById('MasterControlName').value = "Make"; $("#MasterFrame").show(); } function Master_Product_Category() { $("#MasterFrame").attr("src", "WebForms/ManageProductCategories.aspx"); document.getElementById('MasterFormName').value = "Products"; document.getElementById('MasterControlName').value = "Category"; $("#MasterFrame").show(); }
修改文件时间
将文件时间修改为当前时间的前一年
删除文件