internal bool ReadList(out List <RawMaterialsDetailModel> data)
{
bool flag = true;
data = new List <RawMaterialsDetailModel>();
string sql = "select b.Number as Code,b.Name as Name,total(a.Number) as Amount from T_Warehouse_RawMaterials a left join T_ProductInfo_RawMaterials b on a.RawMaterialsID = b.GUID group by a.RawMaterialsID";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
RawMaterialsDetailModel d = new RawMaterialsDetailModel();
d.Id = id;
id++;
d.Code = dr["Code"].ToString();
d.Name = dr["Name"].ToString();
d.Amount = dr["Amount"].ToString();
data.Add(d);
}
}
return(flag);
}
internal bool ReadList(out List <CustomerModel> data)
{
bool flag = true;
data = new List <CustomerModel>();
string sql = "select * from T_UserInfo_Customer Where DeleteMark is null order by AddTime";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
CustomerModel d = new CustomerModel();
d.Guid = (Guid)dr["GUID"];
d.Id = id++;
d.Number = dr["Number"].ToString();
d.Name = dr["Name"].ToString();
d.Address = dr["Address"].ToString();
d.Area = dr["Area"].ToString();
d.Phone = dr["Phone"].ToString();
d.MobilePhone = dr["MobilePhone"].ToString();
d.Fax = dr["Fax"].ToString();
d.Business = dr["Business"].ToString();
d.Clerk = dr["Clerk"].ToString();
d.DebtCeiling = decimal.Parse(dr["DebtCeiling"].ToString());
d.Remark = dr["Remark"].ToString();
d.AddTime = Convert.ToDateTime(dr["AddTime"]);
data.Add(d);
}
}
return(flag);
}
internal bool ReadList(out List <RawMaterialsModel> data)
{
bool flag = true;
data = new List <RawMaterialsModel>();
string sql = "select a.*,b.Number SupplierNumber,b.Name SupplierName "
+ "from T_ProductInfo_RawMaterials a Left Join T_UserInfo_Supplier b On a.Supplier=b.Guid "
+ "Where a.DeleteMark is null order by a.AddTime";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
RawMaterialsModel d = new RawMaterialsModel();
d.Guid = (Guid)dr["GUID"];
d.Id = id++;
d.Number = dr["Number"].ToString();
d.Name = dr["Name"].ToString();
d.Weight = dr["Weight"].ToString();
d.Material = dr["Material"].ToString();
d.SupplierName = dr["SupplierName"].ToString();
d.Sp1 = dr["Sp1"].ToString();
d.Sp2 = dr["Sp2"].ToString();
d.Remark = dr["Remark"].ToString();
d.AddTime = Convert.ToDateTime(dr["AddTime"]);
data.Add(d);
}
}
return(flag);
}
internal Model_AssemblyLineModuleBatchInput ReadProductInfo(string Number)
{
Model_AssemblyLineModuleBatchInput m = new Model_AssemblyLineModuleBatchInput();
string sql = "SELECT GUID,Name,P1,P2,P3,P4,P5,P6 FROM T_ProductInfo_Product WHERE NUMBER='" + Number + "' AND DELETEMARK ISNULL";
DataSet ds = new DataSet();
bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m.ProductGuid = (Guid)dr["GUID"];
m.ProductNumber = Number;
m.ProductName = dr["Name"].ToString();
for (int i = 0; i < 6; i++)
{
if (dr["P" + (i + 1)].ToString() != "无")
{
m.ProcessList[i] = dr["P" + (i + 1)].ToString();
m.ProcessListStr += dr["P" + (i + 1)].ToString() + ",";
}
}
m.ProcessListStr = m.ProcessListStr.Substring(0, m.ProcessListStr.Length - 1);
}
}
return(m);
}
/// <summary>
/// 读取产品详细信息
/// </summary>
/// <param name="ProductNumber">产品编号</param>
/// <returns></returns>
internal Model_WarehouseProductBatchIn ReadProductInfo(string ProductNumber)
{
Model_WarehouseProductBatchIn m = new Model_WarehouseProductBatchIn();
string sql = " SELECT a.GUID,a.Name,a.Material,a.PackageNumber,Total(b.Quantity) as TotalParts "
+ " FROM T_ProductInfo_Product a"
+ " Left join T_Warehouse_Product b ON a.Guid=b.ProductID "
+ " WHERE a.NUMBER='" + ProductNumber + "' "
+ " AND a.DELETEMARK ISNULL"
+ " AND b.DeleteMark ISNULL"
;
DataSet ds = new DataSet();
bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["GUID"].ToString().Length < 5)
{
return(m);
}
m.Guid = (Guid)dr["GUID"];
m.Number = ProductNumber;
m.Name = dr["Name"].ToString();
m.Material = dr["Material"].ToString();
int PerQuantity = 0;
int.TryParse(dr["PackageNumber"].ToString(), out PerQuantity);
m.PerQuantity = PerQuantity;
int TotalParts = 0;
int.TryParse(dr["TotalParts"].ToString(), out TotalParts);
m.TotalParts = TotalParts;
}
}
return(m);
}
internal Model_ProductionManagement_OutsideProcessBatch ReadProductInfo(string ProductNumber)
{
Model_ProductionManagement_OutsideProcessBatch m = new Model_ProductionManagement_OutsideProcessBatch();
string sql = "SELECT GUID,Name,Material,P1,P2,P3,P4,P5,P6 FROM T_ProductInfo_Product WHERE NUMBER='" + ProductNumber + "' AND DELETEMARK ISNULL";
DataSet ds = new DataSet();
bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m.ProductGuid = (Guid)dr["GUID"];
m.ProductNumber = ProductNumber;
m.ProductName = dr["Name"].ToString();
m.Material = dr["Material"].ToString();
for (int i = 1; i < 7; i++)
{
if (dr["P" + i].ToString() == "抛光")
{
m.HasPolishing = true;
}
}
}
}
return(m);
}
internal bool ReadList(string args, out List <ScrapModel> data)
{
args = args.Equals("全部") ? "" : "where Name='" + args + "'";
bool flag = true;
data = new List <ScrapModel>();
string sql = "select GUID,Number,Name,Remark,Operator,strftime(Date) as Date from T_Warehouse_Scrap " + args + " order by Date";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ScrapModel d = new ScrapModel();
d.Guid = (Guid)dr["GUID"];
d.Id = id++;
d.Date = dr["Date"].ToString().Split(' ')[0];
d.Number = dr["Number"].ToString();
d.Name = dr["Name"].ToString();
d.Remark = dr["Remark"].ToString();
d.Operator = dr["Operator"].ToString();
data.Add(d);
}
}
return(flag);
}
internal bool Update(Model.ProductOrderModel d)
{
bool flag = false;
List <string> sqls = new List <string>();
//删掉旧的
string sql_DelOrder = "Delete From T_Orders_Product where Guid='" + d.Guid + "'";
sqls.Add(sql_DelOrder);
string sql_DelDetails = "Delete From T_Orders_ProductDetails where OrderID='" + d.Guid + "'";
sqls.Add(sql_DelDetails);
//插入修改的
string sql_Order = "Insert into T_Orders_Product(Guid,OrderNumber,CustomerID,DeliveryDate,OrderDate) "
+ "Values('" + d.Guid + "','" + d.OrderNumber + "','" + d.CustomerID + "','" + d.DeliveryDate + "','" + d.OrderDate + "')";
sqls.Add(sql_Order);
foreach (Model.ProductOrderDetailsModel dd in d.Details)
{
string sql_Details = "Insert into T_Orders_ProductDetails(Guid,OrderID,ProductID,NumberOfItems,Quantity,Unit,Remark) "
+ "Values('" + dd.Guid + "','" + dd.OrderID + "','" + dd.ProductID + "','" + dd.NumberOfItems + "','" + dd.Quantity + "','" + dd.Unit + "','" + dd.Remark + "')";
sqls.Add(sql_Details);
}
flag = new Helper.SQLite.DBHelper().Transaction(sqls);
return(flag);
}
internal bool GetOrderDetails(Guid OrderID, out List <Model.ProductOrderDetailsModel> dDetails)
{
bool flag = false;
dDetails = new List <Model.ProductOrderDetailsModel>();
string sql = " Select a.*,b.Number as ProductNumber,b.Name as ProductName"
+ " from T_Orders_ProductDetails a "
+ " Left join T_ProductInfo_Product b ON a.ProductID=b.Guid"
+ " where OrderID='" + OrderID + "'";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
Model.ProductOrderDetailsModel d = new Model.ProductOrderDetailsModel();
d.Guid = (Guid)dr["Guid"];
d.Id = id;
d.OrderID = OrderID;
d.ProductID = (Guid)dr["ProductID"];
d.ProductNumber = dr["ProductNumber"].ToString();
d.ProductName = dr["ProductName"].ToString();
d.NumberOfItems = int.Parse(dr["NumberOfItems"].ToString());
d.Quantity = int.Parse(dr["Quantity"].ToString());
d.Unit = dr["Unit"].ToString();
d.Remark = dr["Remark"].ToString();
dDetails.Add(d);
}
}
return(flag);
}
internal bool ReadList(out List <UserModel> data)
{
bool flag = true;
data = new List <UserModel>();
string sql = "select *,case when permissions=0 then '仓库记录员' when permissions=1 then '流水线记录员' else '软件记录员' end as displayPermissions from T_System_User Where DeleteMark is null and Permissions not in (9,8)";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
UserModel d = new UserModel();
d.Rowid = id;
id++;
d.Id = Int32.Parse(dr["ID"].ToString());
d.Username = dr["NAME"].ToString();
d.Password = dr["PASSWORD"].ToString();
d.Realname = dr["REALNAME"].ToString();
d.Permissions = Int32.Parse(dr["PERMISSIONS"].ToString());
d.Remark = dr["REMARK"].ToString();
d.DisplayPermissions = dr["DISPLAYPERMISSIONS"].ToString();
data.Add(d);
}
}
return(flag);
}
internal bool Delete(Guid guid)
{
bool flag = false;
string sql = "Delete From T_PM_ProcessSchedule Where GUID='" + guid + "'";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool Update(UserModel d)
{
bool flag = true;
string sql = "update T_System_User set Password = '******',RealName='" + d.Realname + "',Permissions='" + d.Permissions + "',Remark='" + d.Remark + "' where id = " + d.Id;
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool MarkDelete(CustomerModel d)
{
bool flag = true;
string sql = "Update T_UserInfo_Customer Set DeleteMark='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' Where GUID='" + d.Guid + "'";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool ChangePassword(string Name, string Password)
{
bool flag = false;
string sql = "UPDATE T_System_User SET Password='******' WHERE name='" + Name + "'";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool MarkDelete(Model.ProductOrderModelForDataGrid d)
{
bool flag = true;
string sql = "Update T_Orders_Product Set DeleteMark='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' Where GUID='" + d.Guid + "'";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool MarkDelete(UserModel d)
{
bool flag = true;
string sql = "Update T_System_User Set DeleteMark='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' Where id=" + d.Id + "";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool Add(Model.ScrapModel d)
{
bool flag = true;
string sql = "Insert into T_Warehouse_Scrap(Guid,Name,Date,Operator,Number,Remark) "
+ "values('" + d.Guid + "','" + d.Name + "','" + d.Date + "','" + d.Operator + "','" + d.Number + "','" + d.Remark + "')";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool ReadKeyFromDB(out string Key)
{
object oKey;
string sql = "Select Value From T_System_Settings WHERE ID=1 AND Key='License'";
bool flag = new Helper.SQLite.DBHelper().QuerySingleResult(sql, out oKey);
Key = oKey.ToString();
return(flag);
}
internal bool CheckPassword(string Name, string Password)
{
bool flag = false;
string sql = "select * from T_System_User where Name='" + Name + "' AND Password='******' AND DeleteMark is null";
object o;
flag = new Helper.SQLite.DBHelper().QuerySingleResult(sql, out o);
return(flag);
}
internal bool Add(UserModel d)
{
bool flag = true;
string sql = "Insert Into T_System_User (Name,Password,UserGroup,RealName,Permissions,Remark) "
+ " values('" + d.Username + "','" + d.Password + "',3,'" + d.Realname + "','" + d.Permissions + "','" + d.Remark + "')";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool GetNameList(out DataSet ds)
{
bool flag = true;
ds = new DataSet();
string sql = "select Guid,Number,Name From T_UserInfo_Customer Where DeleteMark is null order by AddTime";
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
return(flag);
}
internal bool GetNameList(string Parm, out DataSet ds)
{
bool flag = true;
ds = new DataSet();
string sql = "select Guid,Number,Name From T_UserInfo_Processors Where (Number LIKE '%" + Parm + "%' OR Name LIKE '%" + Parm + "%') AND DeleteMark is null order by AddTime";
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
return(flag);
}
internal bool ReadList(Guid ProductGuid, out Model.AssemblyLineModuleModel d)
{
bool flag = true;
bool isFirstLine = true;
d = new Model.AssemblyLineModuleModel();
List <Model.AssemblyLineModuleProcessModel> ProcessList = new List <Model.AssemblyLineModuleProcessModel>();
d.Guid = ProductGuid;
string sql = " select "
+ " a.Number,"
+ " a.Name,"
+ " a.P1,"
+ " a.P2,"
+ " a.P3,"
+ " a.P4,"
+ " a.P5,"
+ " a.P6,"
+ " b.Process,"
+ " total(b.Number) as Quantity, "
+ " total(b.Break) as BreakNum "
+ " from T_ProductInfo_Product a "
+ " LEFT JOIN T_PM_ProductionSchedule b ON b.ProductID = a.GUID AND b.DeleteMark IS NULL"
+ " where a.GUID='" + ProductGuid + "' "
+ " GROUP BY b.Process";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
d.Number = dr["Number"].ToString();
d.Name = dr["Name"].ToString();
Model.AssemblyLineModuleProcessModel dp = new Model.AssemblyLineModuleProcessModel();
if (isFirstLine)
{
InitProcessList(dr, ref ProcessList);
isFirstLine = false;
}
for (int i = 0; i < ProcessList.Count; i++)
{
if (ProcessList[i].Process == dr["Process"].ToString())
{
ProcessList[i].Quantity = Convert.ToInt32(dr["Quantity"].ToString());
ProcessList[i].BreakNum = Convert.ToInt32(dr["BreakNum"].ToString());
}
}
}
CalculateProcessList(ProductGuid, ref ProcessList);
d.ProcessList = ProcessList;
}
return(flag);
}
internal bool Add(ProductModel d)
{
if (CheckRepeat(d))
{
return(false);
}
bool flag = true;
string sql = "Insert Into T_ProductInfo_Product (GUID,Number,Name,Material,Type,Specification,P1,P2,P3,P4,P5,P6,PackageNumber,Remark,AddTime) "
+ " values('" + d.Guid + "','" + d.Number + "','" + d.Name + "','" + d.Material + "','" + d.Type + "','" + d.Specification + "','" + d.P1 + "','" + d.P2 + "','" + d.P3 + "','" + d.P4 + "','" + d.P5 + "','" + d.P6 + "','" + d.PackageNumber + "','" + d.Remark + "','" + d.AddTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool Add(CustomerModel d)
{
if (CheckRepeat(d))
{
return(false);
}
bool flag = true;
string sql = "Insert Into T_UserInfo_Customer (GUID,Number,Name,Address,Area,Phone,MobilePhone,Fax,Business,Clerk,DebtCeiling,Remark,AddTime) "
+ " values('" + d.Guid + "','" + d.Number + "','" + d.Name + "','" + d.Address + "','" + d.Area + "','" + d.Phone + "','" + d.MobilePhone + "','" + d.Fax + "','" + d.Business + "','" + d.Clerk + "','" + d.DebtCeiling + "','" + d.Remark + "','" + d.AddTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool Add(RawMaterialsModel d)
{
if (CheckRepeat(d))
{
return(false);
}
bool flag = true;
string sql = "Insert Into T_ProductInfo_RawMaterials (GUID,Number,Name,Weight,Material,Supplier,Sp1,Sp2,Remark,AddTime) "
+ " values('" + d.Guid + "','" + d.Number + "','" + d.Name + "','" + d.Weight + "','" + d.Material + "','" + d.Supplier + "','" + d.Sp1 + "','" + d.Sp2 + "','" + d.Remark + "','" + d.AddTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool ReadList(string ProductType, string Screening, out List <ProductModel> data)
{
string Sql_Where = "";
if (!ProductType.StartsWith("全部"))
{
Sql_Where += " AND Type='" + ProductType + "' ";
}
if (Screening != "")
{
Sql_Where += " AND (Name LIKE '%" + Screening + "%' OR Number LIKE '%" + Screening + "%') ";
}
bool flag = true;
data = new List <ProductModel>();
string sql = " select * "
+ " from T_ProductInfo_Product "
+ " Where DeleteMark is null "
+ Sql_Where
+ " ";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ProductModel d = new ProductModel();
d.Guid = (Guid)dr["GUID"];
d.Id = id++;
d.Number = dr["Number"].ToString();
d.Name = dr["Name"].ToString();
d.Material = dr["Material"].ToString();
d.Type = dr["Type"].ToString();
d.Specification = dr["Specification"].ToString();
d.P1 = dr["P1"].ToString();
d.P2 = dr["P2"].ToString();
d.P3 = dr["P3"].ToString();
d.P4 = dr["P4"].ToString();
d.P5 = dr["P5"].ToString();
d.P6 = dr["P6"].ToString();
GenerateProcess(ref d);
d.PackageNumber = int.Parse(dr["PackageNumber"].ToString());
d.Remark = dr["Remark"].ToString();
d.AddTime = Convert.ToDateTime(dr["AddTime"]);
data.Add(d);
}
}
return(flag);
}
internal bool ReadList(bool ShowDeparture, out List <StaffModel> data)
{
string sql_Where = "";
if (!ShowDeparture)
{
sql_Where += " AND DepartureTime IS '0001-01-01 00:00:00'";
}
bool flag = true;
data = new List <StaffModel>();
string sql = "select * from T_UserInfo_Staff Where DeleteMark is null " + sql_Where + " order by AddTime";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
StaffModel d = new StaffModel();
d.Guid = (Guid)dr["GUID"];
d.Id = id++;
d.Number = dr["Number"].ToString();
d.Name = dr["Name"].ToString();
d.Jobs = dr["Jobs"].ToString();
d.EntryTime = Convert.ToDateTime(dr["EntryTime"]).ToString("yyyy-MM-dd");
//d.Seniority = Helper.Tools.Seniority.SeniorityForMonth(Convert.ToDateTime(dr["EntryTime"]));
d.Contact = dr["Contact"].ToString();
d.IDNumber = dr["IDNumber"].ToString();
d.Remark = dr["Remark"].ToString();
//d.DepartureTime = (Convert.ToDateTime(dr["DepartureTime"]).Year > 10) ? Convert.ToDateTime(dr["DepartureTime"]).ToString("yyyy-MM-dd") : "";
d.AddTime = Convert.ToDateTime(dr["AddTime"]);
if (Convert.ToDateTime(dr["DepartureTime"]).Year > 10)
{
d.DepartureTime = Convert.ToDateTime(dr["DepartureTime"]).ToString("yyyy-MM-dd");
d.Seniority = Helper.Tools.Seniority.SeniorityForMonth(Convert.ToDateTime(dr["EntryTime"]), Convert.ToDateTime(dr["DepartureTime"]));
}
else
{
d.DepartureTime = "";
d.Seniority = Helper.Tools.Seniority.SeniorityForMonth(Convert.ToDateTime(dr["EntryTime"]));
}
data.Add(d);
}
}
return(flag);
}
internal bool Add(StaffModel d)
{
if (CheckRepeat(d))
{
return(false);
}
if (d.DepartureTime == null)
{
d.DepartureTime = "0001-01-01 00:00:00";
}
bool flag = true;
string sql = "Insert Into T_UserInfo_Staff (GUID,Number,Name,Jobs,EntryTime,Contact,IDNumber,Remark,DepartureTime,AddTime) "
+ " values('" + d.Guid + "','" + d.Number + "','" + d.Name + "','" + d.Jobs + "','" + d.EntryTime + "','" + d.Contact + "','" + d.IDNumber + "','" + d.Remark + "','" + d.DepartureTime + "','" + d.AddTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal Model_AssemblyLineModuleBatchInput ReadStaffInfo(string Number)
{
Model_AssemblyLineModuleBatchInput m = new Model_AssemblyLineModuleBatchInput();
string sql = "SELECT GUID,Name FROM T_UserInfo_Staff WHERE NUMBER='" + Number + "' AND DELETEMARK ISNULL";
DataSet ds = new DataSet();
bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m.StaffGuid = (Guid)dr["GUID"];
m.StaffNumber = Number;
m.StaffName = dr["Name"].ToString();
}
}
return(m);
}
