本文整理汇总了C#中Common.qrytime方法的典型用法代码示例。如果您正苦于以下问题:C# Common.qrytime方法的具体用法?C# Common.qrytime怎么用?C# Common.qrytime使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Common
的用法示例。
在下文中一共展示了Common.qrytime方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: insertUserAttribute
public void insertUserAttribute(int USPUserid, int ID, int checkedID)
{
Common common = new Common();
string qry = "insert into user_attribute(UA_user_id,UA_menu,UA_enable,UA_CREATEDBY,UA_CREATEDON)values('" + USPUserid + "','" + ID + "','" + checkedID + "',";
qry += common.qrytime("ins") + ")";
MysqlConn.executeQry(qry);
}
示例2: updateUserPrivilege
public void updateUserPrivilege(int USPUserid)
{
Common common = new Common();
string qry = "update userprivilege set ";
qry += common.qrytime("upd", "USP_");
qry += "where USPUSERID='" + USPUserid + "'";
MysqlConn.executeQry(qry);
}
示例3: updateUserAttribute
public void updateUserAttribute(int USPUserid, int checkedID, int ID)
{
Common common = new Common();
string qry = "update user_attribute set UA_enable='" + checkedID + "',";
qry +=common.qrytime("upd", "UA_");
qry += " where UA_user_id='" + USPUserid + "' and UA_menu='" + ID + "'";
MysqlConn.executeQry(qry);
}
示例4: insertUserPrivileges
public void insertUserPrivileges(string userName, string password)
{
Common common = new Common();
string qry;
qry = "insert into userprivilege(USPUSERNAME,USPPASSWORD,USPCREATEDBY,USPCREATEDON)values('" + userName + "','" + password + "',";
qry += common.qrytime("ins", "USP") + ")";
MysqlConn.executeQry(qry);
}
示例5: saveStaffProof
public void saveStaffProof(string[] Dest_Image_ImagePath, string empNo, bool marriedStatus, bool childProof, bool othrQualProof)
{
Common common = new Common();
string qry = "insert into employee_proof(EP_EMP_NO, EP_EMP_PIC, EP_EMP_DOB_PROOF, EP_EMP_PER_ADDRESS_PROOF, EP_EMP_PRES_ADDRESS_PROOF, EP_EMP_EDU_QUAL_PROOF,EP_EMP_NOCHILD_PROOF,EP_EMP_OTHR_QUAL_PROOF,EP_EMP_CREATED_BY,EP_EMP_CREATED_ON) values ('" + empNo + "',";
for (int i = 0; i < Dest_Image_ImagePath.Length - 2; i++)
qry += "'" + Dest_Image_ImagePath[i].Replace("\\", "\\\\\\").Replace("\\\\\\b", "\\\\b") + "',";
qry += ((marriedStatus) && (childProof)) ? "'" + Dest_Image_ImagePath[6].Replace("\\", "\\\\\\").Replace("\\\\\\b", "\\\\b") + "'," : "NULL,";
qry += (!othrQualProof) ? "'" + Dest_Image_ImagePath[5].Replace("\\", "\\\\\\").Replace("\\\\\\b", "\\\\b") + "')" : "NULL),";
qry += common.qrytime("ins", "EP_EMP_");
MysqlConn.executeQry(qry);
}