C# (CSharp) SqlHelperUtils.ToSingleQuoteString示例

示例#1

文件： CV.cs 项目： kimykunjun/test

        public bool SaveCV(int nCaseID, DataSet ds)
        {
            string cmdtxt = "SELECT * FROM tblCase WHERE nCaseID = '"
                            + SqlHelperUtils.ToSingleQuoteString(nCaseID.ToString()) + "'";

            SqlHelperUtils.UpdateDataSetSingleTableWithTransaction(ds, cmdtxt);
            return(true);
        }

示例#2

文件： CV.cs 项目： kimykunjun/test

        public bool SaveNewCVAction(DataSet dsTblCaseAction, int nCaseID, DataSet dsTblCase)
        {
            string cmdtxt = "SELECT * FROM tblCase WHERE nCaseID = '"
                            + SqlHelperUtils.ToSingleQuoteString(nCaseID.ToString()) + "'";

            SqlHelperUtils.UpdateDataSetTwoTableWithTransaction(dsTblCase, cmdtxt, dsTblCaseAction, cmdtxtTblCaseActionSave);
            return(true);
        }